1 Reply Latest reply: Oct 1, 2015 11:54 AM by Sunny Talwar RSS

    Sum Nested If state in expression

      Currently I have a sum working correctly if one of the two values is selected.  If I select A, i get the sum of the associated column, if I select B, I get the sum of the associated column and if I chose both from the filter box, I get the total summed of the two selection correctly.  The issue I am having is that if nothing is selected in the filter box, I also want to show the total summed since nothing is selected, but current I get a larger number in the KPI box than is possible, so something is double counting


      WARR_CAT is a filter box





      If both are selected and if neither is select I want the sum of MA_WARR_TOTAL_COST_USD


      Any ideas?