locked
Iff Expression RRS feed

  • Question

  • Hello,

     

    I have a matrix report with

     

    a Column called SaleType and rows containing salesreps

     

    Table looks like

     

                  business   home      business2     home2

    John       50             12            0                        120 

    Mary       100           11           50                        23

    Peter      20              10          20                        11

     

    I am trying to create another column called Total Business Sales which is a total off Business + business2

     

    Because it is a matrix report the there is only one column in design mode which represents the business or home types. Not sure how to add the 2 business types together

     

    Im trying an expression =IIf(Fields!SaleType.Value='business' OR 'business2' ,SUM(Fields!Sale.Value),0)

    This only gives me the Sum off ALL the Saletype Value and doesnt determine add up only the values which fall under business or business2...if somehow I can put a condition on the SUM

     

    Can someone please help

     

    thanks

    Thursday, June 21, 2007 2:55 AM