Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Could you please help me to how to write the express to Calculate the Cumulative Total %?
For example:
Upto 10% has 20 unique material numbers and 14 unique supplier numbers.
upto 20% has 48 unique materials and 25 supplier numbers
upto 30% has 72 unique materials and 42 supplier numbers
etc....
The result:
Range% | Total % |
---|---|
Upto 10% | 20 unique materials and 14 unique supplier numbers |
Upto 20% | 68 (48+20) unique materials and 39 (25+14) 100+200) unique suppliers |
Upto 30% | 140 (72+48+20) unique materials and 81 (42+25+14) unique suppliers |
'
In the Attached file please refer column Q (highlighted in yellow), where the % upto 10 should be categorised as "Upto 10%", anything more than 10% but less that 20% should be categorised as "Upto 20%", anything more than 20% but less than 30% should be categorised as "Upto 30%" etc.... however the Range % should show the result as shown in the table (i.e cumulative).
Please help ASAP.
Regards
Vani
Hi
have a look at the attached app
Hi,
Could you please resend the QVF file again.
Regards
Vani