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!