Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
For each product I'd like to calculate the ratio of each validity date in terms of quantity. Please see attached file for incorrect approach. what I am looking for is for Product A it's 100% as it only has one validity date, Product B, should be 40%, 20%, 20% and 20% so that they add up to 100%.
I used the samiliar formula for Sum(total <>...) it worked but now I have to use Count. does the syntas differ for Count?? Thanks!
See the attached.
See the attached.
Nicole- thanks a lot!
I'm glad it worked