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



    Thursday, June 21, 2007 2:55 AM