Aggregation syntax help

[hobanwashburne]

I have a text box in which I want to display sales for a particular month, the following line works:

=num(Sum ({$<FiscalPeriod={201303}>}NetSales),'$#,##0')

Now I want to replace the static text “201303” with either a variable (vGLPR) or the
calculation to get back to the correct month (date(AddMonths(Today(),-4),'YYYYMM')

Let vGLPR = date(AddMonths(Today(),-4),'YYYYMM');

[jerem1234 · Accepted solution]

Try this:

=num(Sum ({$<FiscalPeriod={$(=date(AddMonths(Today(),-4),'YYYYMM'))}>}NetSales),'$#,##0')

[hobanwashburne]

Thank you, does anyone know what the variable method would look like?

[jerem1234]

This should be it:

=num(Sum ({$<FiscalPeriod={'$(vGLPR)'}>}NetSales),'$#,##0')

and let defintion of vGLPR be: =date(AddMonths(Today(),-4),'YYYYMM')