can you please share a workbook or an excel data source?
Thanks Deepak Rai by the answer, it was 90% but it did't made it.
I did got same calculation to count how many new, rfbd or open I have either by receipt as per quarter.
The tricky point that I can't figure out here is:
How to calculate if a receipt contains a single itemCond for all item count in the same receipt.
receiptID# 1 is mixed itemCond
receiptID# 2 is 'Open' itemCond
receiptID# 3 is 'Rfbd' itemCond
receiptID# 4 is 'New' itemCond
receiptID# 5 is 'Open' itemCond
receiptID# 6 is 'Rfbd' itemCond
reading your calculations and the sheets you provided it came clear to me I need to categorize the type of receipt I have. So I was able to make this calculation:
Now how to use this this data at the quarter report ?
counts_v10_v10.2_b.twbx 70.9 KB