Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I wonder (I have something like in the attachment) - how to display all customers in a three-column table (regardless of the sum of sales)?
CustID | Name | Sum(Sales) |
---|---|---|
C100 | ... | 1000 |
C105 | ... | null |
C110 | ... | 0 |
.... | ... | ... |
Hi Kuba, one option is adding "+Sum({1} 0)" to the expression, customers without data will show 0
To set the string 'null' you can try wih:
If(Count(Sales)=0, 'null', Sum(Sales))
Hi,
You have to unclick 'Suppress when value is null' on the Dimensions-tab and then also unclick 'Suppress zero values' in presentation.
I have only:
1) "Include null values" - in dimmension (selected)
2) "Include zero values" - in Add-ons, Data handling (selected)
Didn't work.
Remove suppress zero value from presentation tab too!!
Hi Kuba, one option is adding "+Sum({1} 0)" to the expression, customers without data will show 0
To set the string 'null' you can try wih:
If(Count(Sales)=0, 'null', Sum(Sales))
If you want to show all Names without considering any selection, please use the below expression for sales
Sum({1}Sales)
Thanks rubenmarin!
It works!