Hello,

 

I want to create a column in FRx that is dependent on the current month.  This column is going to be a calculated column.  The business model is that the column will be called 'Q1' and if the month is Mar, then Q1 will be Jan Act  + Feb Act + Mar Budget.  If the month is Apr (or later) then Q1 will be Jan Act+Feb Act+Mar Act

I tried using the following IF/THEN statement:

 

IF @PER = 3 then C+D+H, else C+D+E

It didn't work because the column in which I am placing the formula doesn't have a Period Code - as it is a calculated column.

Does anyone know how I can substitute IF @PER = 3 for something like IF (CurrentMonth) = 3 ?

I am also open to other suggestions too

 

Thanks for your help!

 

Joe