Accumulate Value on Text Box (Balance Value )

[ghassanaldalati]

How to get all the accumulate value on and before the selected month ( As Balance Value )

on other word

all accumulate value for all period up to selected month

Plz Look to my Attachment

[ghassanaldalati]

when I select { month ( May ) - Year ( 2015) } I get all the Accumulate amount from Day 1 up to May2015 (Full ccumulate amount for all years before + 5 months on May2015)

I need the formula on TextBox

[MK_QSL]

Something like below..

SUM({<YourDateField = {"$(=Date(MakeDate(Max(Year),Max(Month))))"}>}Sales)

Change your field names according to your application.

[tresB]

Try something like:

Sum({<Year,Month, Date={'<=$(=Date(Max(Date)))'}>} Value)

[ghassanaldalati]

Plz have a look to my attachment .. and help

[ghassanaldalati]

Plz have a look to my attachment .. and help

[tresB · Accepted solution]

The working expression is: =Sum({<Year,Month, Date={'<=$(=Date(Max(Date)))'}>} Sales)

[MK_QSL]

Use this..

=SUM({<Month, Year, Date = {'<=$(=Date(Max(Date)))'}>}Sales)