Hi All,
I am getting null values when I use the Multi Row formula tool.
Essentially, I want to a cumulative of the second column and the previous row of the 3rd column; Grouped by Trip Number. I am getting null values i.e. no output. Seems pretty simple but I am stuck.
Can anybody please help?
Thanks,
Harshad
Solved! Go to Solution.
Hi Harshad,
Solution is attached.
When adding a null value to an integer, the result will become null. To avoid this, I have set all null values to equal 0 prior to generating the cumulative columns. The resulting formula is:
IIF(isnull([LEG_TM_SCHED]), 0,[LEG_TM_SCHED])
+
IIF(isnull([Row-1:CML_LEG_TM_SCHED]), 0, [Row-1:CML_LEG_TM_SCHED])
Hope this helps!
Leigh
Hi Leigh,
Thanks.
This works!