Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I would like a chart to show the six months ending in the max associated date. I have tried the following:
=SUM({$<CLOSEMONTH_SORT = {">= $(vRolling6MonthMin)"}>}RO_FLAG)
where vRolling6MonthMin is defined as the max date minus six months. This works correctly if a range of more than six months is selected. For example, if I select January thru November, it shows me June thru November. But if I select only November, it shows me only November. How can I make it ignore the date selection, but still determine the range based on the highest selected date?
Thanks for your help.
Add modifiers for the fields you want to be ignored:
=SUM({$<MyMonthField=, CLOSEMONTH_SORT = {">= $(vRolling6MonthMin)"}>}RO_FLAG
Add modifiers for the fields you want to be ignored:
=SUM({$<MyMonthField=, CLOSEMONTH_SORT = {">= $(vRolling6MonthMin)"}>}RO_FLAG
Thanks, Gysbert. That works, but because I am ignoring those fields, I have to define both a beginning and end date--so the expression becomes
=SUM({<CLOSEMONTH_SORT = {">= $(vRolling6MonthMin)"} * {"<= $(vCurrentMonth)"}, YEAR=, QUARTER=, MONTH= >}RO_FLAG)