Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
It would be great if some one suggest on my below issue
I am trying to display sum with and without filed selections . But not getting result correctly. Details are below
Field Name : Month( Applied alternate State1) Field name: Month(Applied alternate state2)
I want to show the sum sales in table
1) if I select month from fields then the sum should be Sum({"State1"} Sales) + Sum({"State2"} Sales)
2) if no selection on month then Sum(Sales)
My expression is if(getselectedcount(month) >1, Sum({"State1"} Sales) + Sum({"State2"} Sales), sum(sales)).
the result is Sum(sales) and it is not working for selected months.
Regards,
Ramki.
Hi
Change your expression to:
if(getselectedcount(month) >0, Sum({"State1"} Sales) + Sum({"State2"} Sales), sum(sales))