Use of Set Modifier with As Of-Table

[Anonymous]

Can one use a set modifier with the As Of-Table as follows:

Sum({$<MonthDiff={"<12"}, [Generic Drug Indicator] = {'YES'}>} Amount)

The above gives me values lower than expected.

Regards.

[sunny_talwar]

Would you be able to share a sample?

[Anonymous]

Many thanks Sunny, please find attached.

The chart in the second tab in container is the one which i am referring to.  The chart in the first tab of the containers has no set modifiers.

Regards.

[sunny_talwar]

I guess I need to ask you what is the expected value? Right now we have these, what would you want them to be?

[Anonymous · Accepted solution]

Many thanks Sunny, i realised that my dimension was wrong it was MonthYear instead of AsOfMonths