4 Replies Latest reply on May 8, 2018 4:06 AM by Anupam Mehta

# MTD running sum

hi all,

Total month sales are ok but the problem is MTD

my MTD sale is may 1st 100, may 2nd 200, may 3rd 500 up to may 31st like this

I want running sum for MTD like

today date is 8th so I want (ist+2nd+3rd------+8th)= (100+200+500+-----+200) like this

I want to show day wise difference for eg:

month        total month sales        MTD                                                         difference

may1          2500                             100                                                             2400

may2           2500                            (1st+2nd day)=(100+200)=300                  2200

may3          2500                             (1st+2nd+3rd day)=(100+200+500)=800  1700 like this

remember I have data up to may 31st I want to calculate may 1st to 8th MTD running sum remaining days I want to show null or zeros

how can I calculate MTD running sum

thanks,

veeru.

• ###### 1. Re: MTD running sum

Hi Chowdary,

hope it helps.

BR,

bharat

• ###### 2. Re: MTD running sum

it's not useful for my requirement

• ###### 3. Re: MTD running sum

Hello Chowdary,

This is exactly what you need, check out below

Create a calculation field

and create one more calculation field according to your data for difference

then place the fields in such way

Thanks,

Lovepreet

• ###### 4. Re: MTD running sum

Hi Chowdary,

Please find the attached twbx for solution.

Regards

Anupam