Help Needed! - Basic Set Analysis - QTD Master item for current quarter with variables

[Anonymous]

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

[Anonymous]

Can someone help on this please?

[sunny_talwar]

Would you be able to share your app with us?

[Anonymous]

Hi Sunny,

Attached is the qvf file.

Thanks!

[sunny_talwar · Accepted solution]

I think you don't have any data for Reported ACV when quarter number = 77

[Anonymous]

Hi Sunny,

You are right! It was indeed an issue with the dataset.

Thanks!