Variable in Chart Formular

[carolin01]

Hello together,

I´m trying to write the following formular:

sum({$<FYear = {$(vPreviousFY)}, FDay =< {'$(vFDay)}', OrderPhase_Desc = {'Revenue'}>}NettAmount$(vCurrency))

The variable vFDay indicates a number e.g. 74. This is the number of the Fiscal Day that I assigned to the day yesterday according to our corporate calendar. Also in the previous year there has been a day with a day number 74 assigned to it. I´m now trying to calculate the sum of the previsous year where the FDay =< 74.

How can I do calculations including the =< sign?

Many thanks for all kind of ideas.

Best regards

Carolin

[michael_maeuser · Accepted solution]

um({$<FYear = {$(vPreviousFY)}, FDay = {'<$(vFDay)'}, OrderPhase_Desc = {'Revenue'}>}NettAmount$(vCurrency))

[carolin01]

Thank you - perfect!!!