We have a database for a customers documented savings. The goal is to have 15% of the actual sales in documented savings.

We created a favorite and it doesn’t seem to be working properly. We have 2 streams 1 for sales and 1 for Savings (MSS). We added the variance (MSS - Sales). Then we put in a variance formula in custom mode

Invoice% variance MSS % Sales and format as 1234.57%. This isn’t giving us the right numbers. Any advice?

I’ll take a stab at it, though without a bit more info, I may be barking up the wrong tree.

If the MSS figure is the total documented savings for the customer, I would think rather than using the built in variance feature, you would want to do a calculation of (MSS / Sales) * 100.

So, for example, if I have a customer with $1,000 in sales, and $120 in savings (MSS), then my calculation is going to be (120 / 1000) * 100, which gives me 12%.

Using these same example figures, if I use the built in Variance calculation, I’m going to get -88%. The variance calculation is basically doing ((a-b)/b) * 100. So plugging in my sample numbers, would be ((120-1000)/1000) * 100 = -88.0

Variance is giving you how far one number is off from the other number. Where as it sounds like your simply wanting what percent of one number the other is. So the “MSS / Sales” calculation I would think would be the way to go.

But again, maybe I completely miss understood. If so, any clarification or example figures would be great!

1 Like

Thanks for helping. The formula just isn’t working. I can’t make sense of it

I would be interested to see the selection screens and time periods for values **a** and **b**. It might have something to do with that. I’m wondering if those selections are showing different time periods than the ones listed above of Jan 2019 to Feb 2019.

1 Like

I think @aaron.roma has made a perfectly good suggestion and I am with @tim.janes on this one, the period selections must not be lining up correctly to come up with those calculations.

This was my issue. I 'm still learning I keep “Assuming” my dates will stay the same as my original selection. I now know this isn’t the case in custom mode. Thanks so much!

1 Like