3 Replies Latest reply: Aug 22, 2013 4:16 AM by Mirjam Ribeiro de Oliveira

# Definitions Sales Difference and Sales Variance

Can someone help me with these definitions? In the table, he gives a Sales Difference of 0 and a Sales Variance from 100%.

What do I do wrong in the definitions?

Sales Difference:

([Sales
\$(vMaxYear)]
- [Sales
\$(vPriorYear)]
)

Sales Variance:

If([Sales
\$(vPriorYear)]
= 0,1,([Sales
\$(vMaxYear)]
- [Sales
\$(vPriorYear)]
) / fabs([Sales
\$(vPriorYear)]
))
//If statement needed for situation vPriorYear = 0
//fabs statement needed for situation vPriorYear = negative

Mirjam

• ###### Re: Definitions Sales Difference and Sales Variance

You simply set the variance to 1 if the Sales of the prior year is 0:

If([Sales
\$(vPriorYear)]
= 0,1

1 is 100%. You don't check if Sales of max year has a value of zero or not.

• ###### Re: Definitions Sales Difference and Sales Variance

This formula is not correct, he doesn't calculate the formula this way:

,([Sales
\$(vMaxYear)]
- [Sales
\$(vPriorYear)]
) / fabs([Sales
\$(vPriorYear)]
)

• ###### Re: Definitions Sales Difference and Sales Variance

Right formula:

Sales Variance:

If ([Sales
Difference]
= 0,0,(If([Sales
\$(vPriorYear)]
= 0,1,([Sales
\$(vMaxYear)]
- [Sales
\$(vPriorYear)]
) / fabs([Sales
\$(vPriorYear)]
))))

//If statement nodig voor situatie Sales Difference = 0
//If statement nodig voor situatie Sales vPriorYear = 0
//fabs statement nodig voor situatie Sales vPriorYear = negatief