Future Calender

[george456]

Dear Community

I have a problem to solve. I do not know what the best way is to do this:

I have a calendar that has future dates because of forecasting values. Actual Sales however is one month in arrears.

I have to figure out what I can use as Max date based on Actual Sales 

I hope this make sense

Thanks

[jonathandienst · Accepted solution]

If the amount/value field is null for the future dates, then something along the lines of 

=Max({<Amount={'"*"}>} Date)

Otherwise, add a flag field in the load script that indicates actual values

=Max({<ActualFlag = {1}>} Date)

[george456]

Hi

Thanks worked like a charm: I just had to adapt a bit please see my syntax

=Max({<Type={'Sales Achieved'},Units={"*"}>}Month)

Regards