Palo Community Forum

Good afternoon,

First of all congrats for the speed improvement with this new release: the same reports runs from 2.5 minutes to just 10 seconds now... great results !

unfortunately though a central rule does not work anymore. I have several rules, all working, except for one, containing a IF formula.

when i try only the "value if false" it works fine; only the "value if true" works as well... have you heard about a bug concerning the IF function?

additional info:
- the bug itself is that I receive a gigantic figure (10.000 Billion euros).
- i am calculating the FTE cost of a project: the info is coming from two cubes:
- the same cube, giving the number of FTE
- another cube (HR) giving the cost of the FTEs
- the IF function is there to use a fixed figure in case no data (the 'zero' value) comes from the HR cube
- formula:
['euros externe'] = B:[['FTE externe']] * IF(PALO.DATA("ICTRArun","HR",!'Office',"External","Average cost Ext") > 0,PALO.DATA("ICTRArun","HR",!'Office',"External","Average cost Ext"),126000)

Thanks a lot in advance!
Louis

Good morning,

In this case it is a very simple IF statement.

if you want to replicate the bug, you can try this:
1. create a rule, having in the CONDITION argument a value coming from an other cube with a PALO.DATA
2. set 1 if true and 0 if false, for instance
3. when i calculate, i always have 58.000 as result, no matter if the condition is met or not

Strange isn't it?