Muhammad Mujtaba
Last answered:

17 Nov 2022

 Posted on:

17 Nov 2022
0

Why you added -1 in %variations after dividing both years' value?

in Data Analysis with Excel Pivot Tables / Inserting formulas and automating calculations

Why you added -1 in %variations after dividing both years' value?

1 answers ( 0 marked as helpful)
Aiman Abducarim
Posted on:

17 Nov 2022
1

Hi fellow 365datascience learner!

I tried to expand/explain it in my own way in this question which was also initially answered by Ned, in this link:
https://365datascience.com/q/1c2054b608

hope it helps!

Regards

Submit an answer

related questions

Muhammad Ali Jafri
0
6
Don't understand why am i getting error in some cells while others are responding fine.
Panagiotis Blatsas
0
6
Can you please explain how to fill the table GETPIVOTDATA in practice exam 2?
Abrar Muhtasim
0
6
Resolved: Not finding "option" after selecting slicer
Matthew Marez
2
4
Resolved: Why did he subtract 1from the Var %?
Paulo Valdivia
0
4
Why is the file identified as a trojan?
Nicolas Dgebe
1
2
How does your data get immediately formated as soon as you paste the formula into other cells
Mohamad Ahamad Hassan
0
2
val % method of calculation why the -1 ?
mohammed Umer
1
2
Unable to get the value by fixing this as well