Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to calculate the % Increase of different values in a straight table. My table is below with the values filled in for % Increase that I would expect to get. For each "Contract_ID" I want to calculate the % increase in Bid Amount from rank 1 to 2, then 2 to 3 and so on. Any advice is much appreciated.
Thansk!
Contract_ID | Rank | Bid Amount $ | % Increase |
200918-A01 | 1 | $ 2,897,636.14 | - |
200918-A01 | 2 | $ 2,923,246.15 | 0.88% |
200918-A01 | 3 | $ 3,304,201.46 | 13.03% |
200918-C01 | 1 | $ 2,106,167.49 | - |
200918-C01 | 2 | $ 2,383,955.03 | 13.19% |
200918-C01 | 3 | $ 2,681,826.00 | 12.49% |
200918-C01 | 4 | $ 2,798,363.96 | 4.35% |
200918-C02 | 1 | $ 2,681,859.59 | - |
200918-C02 | 2 | $ 3,247,232.20 | 21.08% |
200918-C03 | 1 | $ 795,433.11 | - |
200918-C03 | 2 | $ 835,098.31 | 4.99% |
200918-C03 | 3 | $ 871,940.00 | 4.41% |
200918-C03 | 4 | $ 896,818.69 | 2.85% |
200918-C03 | 5 | $ 950,306.17 | 5.96% |
200918-C03 | 6 | $ 960,714.62 | 1.10% |
200918-C03 | 7 | $ 966,705.32 | 0.62% |
200918-C03 | 8 | $ 1,086,237.48 | 12.36% |
200918-C03 | 9 | $ 1,213,890.30 | 11.75% |
Should just be this
Sum([Bid Amount])/Above(Sum([Bid Amount])) - 1
@robertsb41 would you be able to share a sample where we can see the issue?
Thanks for your help.
You are the best. Thank you!