locked
how do i put ssrs expression to add two fields? RRS feed

  • Question

  • I have generated one ssrs report

    now i have two fields having values

    1st field value =Fields!FirstNO.Value

    2nd field value = Fields!SecondNO.Value

    now i have one field average and i need to wriet expression like

    average = (Fields!FirstNO.Value+Fields!SecondNO.Value) / (Fields!SecondNO.Value)

    how can i write above in expression?? directly as i shown or any other syntax is there please help?


    Ashish Fugat (9960978134) Software Engineer
    Friday, September 23, 2011 12:48 PM

Answers

  • The expression you have written is the valid one. It will work for the functionality of the expression = (a+b)/a

    = (Fields!FirstNO.Value+Fields!SecondNO.Value) / (Fields!SecondNO.Value)

    Provided, those two fields are numbers like integer, double, etc


    Bunch of thanks ~ Deva ~ mark it as answer if it answered your question :)
    • Marked as answer by ashuthinks32 Friday, September 23, 2011 1:58 PM
    Friday, September 23, 2011 1:14 PM