topic Re: Set summary to zero when no selection applied in App Development

Set summary to zero when no selection applied

Anonymous — Wed, 19 Apr 2017 09:40:56 GMT

Hi,

I have a chart object that totals the current aged debt of a customer(s) when one (or more) are selected (filtered) but when no customer is selected the total aged debt for all records in the data set is displayed.

Is there a away to display zero when no customer is selected?

I'll continue to research but if someone knows the answer please tell.

Thanks,
Roger

Re: Set summary to zero when no selection applied

Anonymous — Wed, 19 Apr 2017 09:53:47 GMT

Hi All,

Problem solved.

For those that need to know the following limits the totaling to 1 filter value.

if (Count(Distinct account_ref) > 1,0, Sum(AGED_CURRENT))

I still think there must be a cleaner solution but can't find it (yet).

Roger

Re: Set summary to zero when no selection applied

vinieme12 — Wed, 19 Apr 2017 10:21:31 GMT

Sum(if(GetSelectedCount(account_ref),AGED_CURRENT))

if(GetSelectedCount(account_ref),sum(AGED_CURRENT),0)

Re: Set summary to zero when no selection applied

Anonymous — Wed, 19 Apr 2017 10:56:51 GMT

Hi Vineeth,

Thanks for the response, both work perfectly thank you.

I knew there had to be an existing variable but just couldn't find it.

Re: Set summary to zero when no selection applied

vinieme12 — Wed, 19 Apr 2017 12:17:55 GMT

Glad to help

Cheers