Skip to Content
avatar image
Former Member

BFC 10 : adding formula to report header

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 14, 2017 at 04:54 PM

    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

    Add comment
    10|10000 characters needed characters exceeded