Hyperion Financial Reporting Formulas error

Vivek Yadav

Hi All,

I am working on a report, here i am using a formula in row for a condition where if on a cell the value is zero then the condition should return zero, if the cell value is not zero then it need to execute a expression.  the formula i am using is showing below:

IfThen(Grid2.Cell[28,A]=0,0,Eval((Grid3.Cell[27,A]/Grid7.Cell[1,A])*Grid7.Cell[1,F]/Grid2.Cell[28,A]))

Is something or wrong or i should try something else!

Vivek Yadav

Vivek Yadav

i also tried the formula on new row and also opposite the conditions, still for both true and falls condition the formula is executing.

3608461

HI,

I Tried the same condition for me it is showing the Correct Results

IF it is true then giving the results as True else false

Ifthen(Grid1.cell[1,A]<>0,0,Eval((Grid2.Cell[2,A]/Grid2.Cell[3,A])*Grid1.Cell[4,A]))

In Grid1.Cell[1,A]=0

     Grid2.Cell[2,A]=2

     Grid2.Cell[3,A]=2

     Grid1.Cell[4,A]=4

Results

4 Because my condition is false

0 when Ifthen(Grid1.cell[1,A]=0,0,Eval((Grid2.Cell[2,A]/Grid2.Cell[3,A])*Grid1.Cell[4,A]))