GetSelectedCount with Alternate states

Ramki — Tue, 30 Nov 2021 18:17:33 GMT

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.

Re: GetSelectedCount with Alternate states

Michael_K — Sun, 25 Jul 2021 06:59:23 GMT

Change your expression to:
if(getselectedcount(month) >0, Sum({"State1"} Sales) + Sum({"State2"} Sales), sum(sales))