Multi row formula tool

[shivraj_r]

Hi All,

I'm trying to do a calculation using the multi row formula tool but for some reason I keep getting -1 as the output in the column! Logic is pretty straightforward.Anyone know why? Attaching screenshots here

[ponraj · Accepted solution]

Here is the solution for your case. 

SampleDataWorkflowMultirowformulatoolResults

[shivraj_r]

@ponraj Thanks! Worked perfectly! On a sidenote - what was wrong with my logic? And is there a particular reason to use IIF over IF?

[ponraj]

Same can be achieved using IF as well.  Here is the expression. 

IF [event_id]=="onProjectStateDetached"&&[Row-1:event_id]=="onProjectStateAttached" THEN [uptime]-[Row-1:uptime] ELSE 0 ENDIF