topic Re: Calculate % Increase in App Development

Calculate % Increase

robertsb41 — Sat, 16 Nov 2024 01:18:20 GMT

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%

Re: Calculate % Increase

sunny_talwar — Tue, 13 Oct 2020 16:53:38 GMT

Should just be this

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

Re: Calculate % Increase

robertsb41 — Tue, 13 Oct 2020 17:05:03 GMT

This returns all null values.

Re: Calculate % Increase

sunny_talwar — Tue, 13 Oct 2020 17:48:50 GMT

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

Re: Calculate % Increase

robertsb41 — Tue, 13 Oct 2020 17:59:02 GMT

Thanks for your help.

Re: Calculate % Increase

sunny_talwar — Tue, 13 Oct 2020 19:20:15 GMT

@robertsb41 try this

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

Re: Calculate % Increase

robertsb41 — Tue, 13 Oct 2020 19:27:45 GMT

You are the best. Thank you!