Calculate % Increase

[robertsb41]

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%

[sunny_talwar]

Should just be this

Sum([Bid Amount])/Above(Sum([Bid Amount])) - 1

[robertsb41]

This returns all null values.

[sunny_talwar]

@robertsb41 would you be able to share a sample where we can see the issue?

[robertsb41]

Thanks for your help.

[sunny_talwar · Accepted solution]

@robertsb41  try this

Aggr(Sum([Bid_Amount])/Above(Sum([Bid_Amount])) - 1, Contract_ID, Rank)

[robertsb41]

You are the best.  Thank you!