cancel
Showing results for 
Search instead for 
Did you mean: 

BFC 10 : adding formula to report header

0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

Marc_Kuipers
Product and Topic Expert
Product and Topic Expert
0 Kudos

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