4 Replies Latest reply: Sep 17, 2017 2:11 AM by Anand Chouhan RSS

    Total sum wont come after applying the expression!

    NEVILLE DHAMSIRI

      Hi,

      Dear guys,

       

      I need to get the sum by applying the formula given below. Can someone to suggest me where I should modify this expression. What I simply need is to if the Actual is greater than the budget, for the all stated telephone numbers for the stated Months, to calculate the amount to be recovered. I get the exact output but the issue is it wont get the sum in the row. I may attach the related pivot table for your reference as well.

       

      IF(Actual>BUDGET,SUM({<Telephone_number={'077_4352506','077_3139047','077_2980266','077_6942156','077_3139049'},Month={'January','February','March','Ápril','May','June'}>}(Actual-BUDGET*1)),0)

       

      Neville