Reply
Frequent Visitor
Posts: 7
Registered: ‎03-28-2017
Accepted Solution

Quck Calculation MOM and YOY % not calculating correctly.

I am trying to use the quick calculation for MOM and YOY for a data set.  It is not calculating it correctly.  For example my January 2017 data is greater than January 2016, yet it is showing on the visual as a - %; clearly incorrect.  Does this have to do with how my date is set up in the data set?  In one column it has day, month and year? I was thinking maybe change it to just month and year? 

Any help would be appreciated.

 

 


Accepted Solutions
Frequent Visitor
Posts: 7
Registered: ‎03-28-2017

Re: Quck Calculation MOM and YOY % not calculating correctly.

I had to alter the calculation on the date portion.  It was -1, and I needed it to read -12. 

Now the calculation and visuals are accurate.

 

View solution in original post


All Replies
Moderator
Posts: 2,588
Registered: ‎03-06-2016

Re: Quck Calculation MOM and YOY % not calculating correctly.

@AKF75

 

I haven't encountered this issue.

 

555.PNG

 

Since it uses DATEADD() function, make sure you have a full calendar dates in your table.

 

Can you share some sample data?

 

Regards,

Frequent Visitor
Posts: 7
Registered: ‎03-28-2017

Re: Quck Calculation MOM and YOY % not calculating correctly.

I had to alter the calculation on the date portion.  It was -1, and I needed it to read -12. 

Now the calculation and visuals are accurate.