Forum Stats

  • 3,854,763 Users
  • 2,264,418 Discussions
  • 7,905,777 Comments

Discussions

Hyperion Financial Reporting Formulas error

Vivek Yadav
Vivek Yadav Member Posts: 24
edited Mar 20, 2018 12:44AM in Hyperion Query and Reporting

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

Answers

  • Vivek Yadav
    Vivek Yadav 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.

  • 3608461
    3608461 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.