Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Friends,
Need some help with Set Analysis!!
I am trying to compute the QTD Value for a measure. I have created it as a Master item. I need it to compute for the current quarter. I have variables defined which give the current quarter. I have referenced these variables in the Master item. But for some reason if I pull the Master item in a table it displays only 0.
This is the formula in my Master item
Sum({$<Year=, Quarter=, Month=, [Cal Quarter Number]={$(vCurrentQtr)}, [Cal Month Number]={"<=$(vCurrentPeriod)"}>} [Reported Sales])/1000
This is the table without the measure which shows the right values
This is the table with the measure which shows the 0 values
I think you don't have any data for Reported ACV when quarter number = 77
Can someone help on this please?
Would you be able to share your app with us?
Hi Sunny,
Attached is the qvf file.
Thanks!
I think you don't have any data for Reported ACV when quarter number = 77
Hi Sunny,
You are right! It was indeed an issue with the dataset.
Thanks!