topic Re: Sum by Dimension Show Hide in App Development

Sum by Dimension Show Hide

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

HI,

I have a dimension called 'User' and an expression Sum(Daily Sales).

I would like to show a text object if any User has a daily sales amount of over 20.

IF anyone can help with the correct show/hide expression please I'd be very grateful.

Many thanks,

Dai

Re: Sum by Dimension Show Hide

MayilVahanan — Mon, 05 Jul 2021 10:04:58 GMT

Try like below

=Count({<User={"=Sum(DailySales)>0"}>}Distinct User)

Re: Sum by Dimension Show Hide

Senor_Dai — Mon, 05 Jul 2021 11:07:12 GMT

Hi @MayilVahanan ,

Thanks for the reply. If I wanted to add a date to this eg, only for today, would the expression be

=Count({<User={"=Sum(DailySales)>0"}, Sale_Date={'Today()'}>}Distinct User)

Also, can you explain how this ensures that only sales over 20 will cause the obejct to display or do I need to add it the expression:

=Count({<User={"=Sum(DailySales)>0"}, Sale_Date={'Today()'}>}Distinct User)>20

Re: Sum by Dimension Show Hide

MayilVahanan — Tue, 06 Jul 2021 00:59:31 GMT

Try like below in the object to display

=Count({<User={"=Sum({<Sale_Date= {'$(=Date(Today()))'}>}DailySales)>20"}>}Distinct User)

, for understanding, you can try like below also.

=if(Count({<User={"=Sum({<Sale_Date= {'$(=Date(Today()))'}>}DailySales)>20"}>}Distinct User) > 1, 1, 0)

Re: Sum by Dimension Show Hide

yangkuki — Thu, 11 Nov 2021 07:20:04 GMT

application useful word unscrambler