Skip to Content
0

BFC 10 : adding formula to report header

Apr 14, 2017 at 03:01 PM

78

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Marc Kuipers
Apr 14, 2017 at 04:54 PM
0

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


fc1.jpg (38.6 kB)
fc2.jpg (44.8 kB)
Share
10 |10000 characters needed characters left characters exceeded