AnsweredAssumed Answered

How can I calculate difference between sales values for different quarters, per client?

Question asked by SwissMac on Dec 23, 2012
Latest reply on Jan 29, 2013 by philmodjunk

Title

How can I calculate difference between sales values for different quarters, per client?

Post

     Every quarter I have to enter the total sales for that quarter for each client. I would like to compare this to the previous quarter on a per client basis and have searched on the forum but can't find anything. How can I do this please? I am calculating the quarter name eg "2012 Q2" from the relevant date field at the end of each quarter but don't know how to make FMP calculate:

     Sales 2012 Q2 - Sales 2012 Q1

     or

     Sales 2012 Q1 - Sales 2011 Q4

     How do I identify which exact record FMP should take? It would be great if FMP always took the most recent quarter and compared it to the one immediately preceding it, or with zero if nothing is there.

     TIA

Outcomes