## Forum Stats

• 3,874,333 Users
• 2,266,724 Discussions

Discussions

# Hyperion Financial Reporting Formulas error

Member Posts: 24
edited Mar 20, 2018 12:44AM

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!

Tagged:

• Member Posts: 24
edited Feb 26, 2018 10:09AM

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

• Member Posts: 24
edited Mar 20, 2018 12:44AM

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]))

This discussion has been closed.