I need to create a column by subtracting lag of each rows, unable to determine how can this be achieved.
Hello @Pranjal_m ,
I am not able to exactly understand what you need to do, but you should be able to solve your problem by lagging columns using a Lag node (or this one, in case of nagative lag) and a column expressions node for the subtraction.
If you need more specific instructions, attach a small example where you show what you need to do, so I can better help.
Have a nice day,
Raffaello
3 Likes
@Pranjal_m
You can achieve your ‘yellow’ calculated columns with 3 nodes:
- Lag Column
- Math Formula $Incremental Recovery$:
( $Outstanding(-1)$ - $Outstanding$ ) / $Outstanding(-1)$
- Moving Aggregation: (Sum Aggregation w. window length == table length)
BR
2 Likes
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.