BFC 10 : adding formula to report header

[gelis36]

In the report header cell we need to write formula that displays different text depending on period. However we receive an error “Error in formula”

The formula we’re trying to add is something like

IF(FUNCPER(REF_PER)[mm]=”12”;”0”;”1”)

Maybe anyone have an idea how to solve it?

[Marc_Kuipers]

Hello Natalija,

I think the problem is the fact that a header cell is of type "text" whereas the IF statements expect numericals

There is a workaround, by not using the header, but putting in a 'empty' row

In this cell, you can use the formula = IF (MONTH_OF (REF_PER) = 12 ; 0 ; 1)

When running, you get the expected result

I hope this helps?

Marc