Any tips how to simplify more than 50 @If formula for months dependant formula?

HCL Domino Domino Forum
1

I have a column in my view, which is time dependant. It will compared current date with Year Field, and display respective Actual or forecast numbers:

The period concerned is financialy year i.e April to March following Year:

Eg:, Column December,

It will first check what is current’s period, via @Month formula, If now is still November, it will pickup documents with status “Forecast”, and provided the value in the month “November”. But if the current months is October till April 2006, it will show the values in the “Actual” field.

What I did was to construct a long list of variable formula:

x:=@if(@Month(@Now)=1 & @Year(@Now)=FieldYear,FieldActual;“”);

…

x:=@if(@Month(@Now)=12 & @Year(@Now)=FieldYear,FieldActual;w);

y:=@if(@Month(@Now)=11 & @Year(@Now)=FieldYear,FieldActual;x);

z:=@if(@Month(@Now)=10 & @Year(@Now)=FieldYear,FieldActual;y);

2

Subject: Any tips how to simplify more than 50 @If formula for months dependant formula?

Do you have a FieldMonth on the form? Can you calculate the month? If so, you should be able to do:

@If(@Month(@Now) = FieldMonth & @Year(@Now) = FieldYear; Forecast; FieldActual)

3

Subject: RE: Any tips how to simplify more than 50 @If formula for months dependant formula?

But my formula for forecast and dependant, depand on the FieldStatus, if FieldStatus=“Forecast”, it will take the value of FieldNov if calendar month now is December, otherwise it will be zero.

However, if current month is November, and if FieldStatus is actual, it will take the value from FieldActual.

Does that mean my formula will have to be long winded , like what I proposed earlier?