Variable in Set Analysis

[cbaqir]

Why would this expression give me Error in set modifier ah doc element list?

=SUM({<FCST_DATE={'$(vPriorQuarter)'},FCST_AMT)

[cbaqir]

vPriorQuarter is a single end date of the latest quarter. That is what I want to use to identify the row of the FCST_AMT.

='vPriorQuarter = '& $(vPriorQuarter) produces 09-30-2015

"If you use this expression in a Straight Table with an empty label, what formula do you see in the heading? You should be able to see how the variable gets expanded, and that might show you what could be wrong."

I see 09-30-2015

[sunny_talwar · Accepted solution]

I think you should probably add another dollar sign expansion -> $(=$(vPriorQuarter)), and secondly make sure that the date format for FCST_AMT is MM-DD-YYYY.

Try this may be:

=Sum({$<FCST_DATE={'$(=$(vPriorQuarter))'}>}FCST_AMT)

[cbaqir]

That was it! Thanks! I'll get the hang of this syntax one day!

[swuehl]

So my guess was right ?!