Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have expressions
like
sum(Current Sales) - current year sales
Sum(Previous Sales) - Prev year sales
sum(Current Sales)- Sum(Previous Sales) - Difference
then How to find difference in percentage
What do you mean how to find difference in percentage? Difference/Prev Year Sales, but I am guessing your question is not as simple as just that, right? Can you elaborate what exactly is it that you are trying to do?
Best,
Sunny
What do you mean how to find difference in percentage? Difference/Prev Year Sales, but I am guessing your question is not as simple as just that, right? Can you elaborate what exactly is it that you are trying to do?
Best,
Sunny
Hi SunIndia,
Your answer is correct
diff/Prev sales *100
Awesome!