On the screenshots below for 1. it should have Cover Qty LM = 1.363 and Cover Qty LY = 2.664 for the top line result.
I cant seem to get it to work. What am I missing?
ResultsGI
Page 1 / 1
Hello @ryonxan ,
It’s hard to answer without seeing the complete Results with labels and the grouping tab. Specifically, How are you Calculating ARTran.Qty?
ARTran.Qty is the quantity sold on one line of one invoice, unless you are aggregating something. We can’t tell if you’re aggregating anything, or how it might be aggregated, with the limited screen shots shown.
It seems like Qty on Hand = Cover Quantity because in your example, ARTran.Qty = 1.
Can we please see Grouping, Joins, etc. or just post the XML? Many people like to download your XML before answering.
Laura
Sorry for that, here is the XML
Hello @ryonxan,
I took your inquiry and imported it into my local instance and began working on your formula. My Data was too old to produce any values for the “SoldLast30” formula but I was able to get the desired result for the “Cover Qty LY” Formula with my data in my instance. Pasted below is the Formula that I used. The first part is a simple if statement used to remove any divide by zero errors, and within the if statements True Part is the formula that essentially does (Qty on Hand / Sold365Avg).