Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm trying to create a load script that will create column E.
Essentially I'm trying to cap my transaction by column A, column B represents transaction sorted by time.
Thank you for your help.
See attached qvw.
Gysbert,
Can you please share brief description steps, about the solution you posted.
Thanks,
Angad
Thank you very much for your help.
The only thing it doesn't do is Cap the first transaction row if it is above the cap.
Example, if the row1 column c had a value of 350. The code sows 350, it should show 250.
Made the small change to get the capping on the first row. Thank you again for your help.
if(previous(P)=P, if(previous(CumTrans) < $(vCap), rangemin(Transaction,$(vCap)-previous(CumTrans)),0),If(Transaction > $(vCap),$(vCap),Transaction)) as Cappd2