Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
could any one of you please help me in writing the expression for finding the Range%.
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) unique suppliers |
Upto 30% | 140 (72+48+20) unique materials and 81 (42+25+14) unique suppliers |
'
In the Attached file please refer column N (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 reply via a screenshot of the expression and not via the QVF/QVD file.
Regards
Vani Y N