Cumulative Sum Till Today - POS Rate Calculation

[Former Member]

Hi,

I need to calculate rate of sales based on POS data. Assuming POS data is updated daily, I want to see what is the rate of sale till today

Any suggestions on how this can be achieved

[ankpatel · Accepted solution]

Hi Vijay

Are you looking for monthly rate or cumulative monthly rate (cumulative sum of month till date)?

Assuming you are looking for Monthly calculation here,

POS Sale rate = (Previous month POS data - Current month POS data) / Previous month POS data

Regards

Ankur