Hi all,
I have a problem where if the 'used' column goes above the 'authorized' column then we need to start adding to the 'used' column below.
For example, when we use over 700m of our authority (total authority is 1.55 billion) then we need to start adding to the 2nd line of 'used'
i.e. if we have used 790 million then 700 would go to the first line and 90 would go to the 2nd.
This would be the output
700 m authorized, 700m used, 0 available
750 m authorized, 90m used, 660m available
I am working in magic etl and am not sure how to set this up. I was thinking a rank and order but am not sure how the logic would work on it.
We have a dataflow that can automatically update the 'used' portion but the authorized portion is coming from a webform that multiple people use.
Does anyone have any insight?