Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Could you please some one can help me to resolve following Issue.
Currently we are having a product and it's Sales. Sales were updating every week. So we want to show Product and current week sales.
So I am using Product as Dimension and in Expression following code I am using
sum({<Year = {'2020'},week={"$(=Week(max(Today())))"}>}Sales)
But in Current week Sales has not yet uploaded. Then it have to show a Table Like Product and 0 as a values. But I am getting following Table
But I need a Table to see like below
Can some one please help to resolve this Issue. I have already checked Include zero values in Adds-on but it's not working.
You can find sample qvf file. Please help me to resolve this Issue
Thanks and Regards,
Satya
attached new version :
Thank you so much brother. It's work as expected
attached new version :
Thank you so much brother. It's work as expected
Hi,
Actually I'm facing the same issue, but unable to open the QVF file. Can you post the answer here to solve this.
Thanks,
Srivani K
Hi SriVani,
Here is the expression we have used.
sum(aggr(sum({<Year = {'2020'},week={"$(=Week(max(Today())))"}>}Sales),Product))
Thanks,
Satya