Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Geeks,
I am using Set analysis to show Product wise sales for every ID.
Eg:- Sum({<Product={'A'}>}Sales)
Please find attached QVW and data file.
Question:
I want to display Sum as Null if no Products are available for a particular id like in below example:
For ID 1 products available are A and B so I don't Want to Show "0" but Null().
Sum(Sales) for a particular product can be Zero or Null()
Appreciate your help.
Thanks and Regards,
Pankaj
You wrote
Sum(Sales) for a particular product can be Zero or Null()
May be this
If(Count({<Product={'A'}>} Product)> 0,Sum({<Product={'A'}>} Sales))
May be use a pivot table or use an expression like this
If(Sum({<Product={'A'}>}Sales), Sum({<Product={'A'}>}Sales))
Thanks Sunny.
What if i also want to show Sum(Sales) as Zero as Well?
You wrote
Sum(Sales) for a particular product can be Zero or Null()
May be this
If(Count({<Product={'A'}>} Product)> 0,Sum({<Product={'A'}>} Sales))
What do you mean that you want to show it as 0 and null both at the same time?
Thanks, You both are Gem
Cheers!!!!