Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Hyperion Financial Reporting Formulas error

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
-
i also tried the formula on new row and also opposite the conditions, still for both true and falls condition the formula is executing.
-
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]))