This content has been marked as final. Show 3 replies
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!