on 04-14-2017 4:01 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.