Financial reporting Studio - IfThen
Hello Dear,
I'm using FRS 11.1.2.3.503 and my requirement is to calculate the cell values based on IfThen statement.
Requirement :-
If((cell[13,a]>0,cell[13,a]+cell[13,B]+cell[13,C]+cell[13,D]+cell[13,E]+cell[13,F],0)
but unfortunately the above logic is not working and would request to help me in correcting the logic.
If Cell[13,a] is greater than 0, then it should calculate and display the sum of Cell[13:a] to Cell[13,F] or else it should display 0.
Thanks in advance for your help.