Date

[mario-sarkis]

Hey all,

my question is i have a field of Date and amount for example:

PerioDate : is to field of Date as number

i need to calculate in a BAR CHART

1- Sum({<periodDate=MaxDate>}amount)  (Current date)

2- Sum(({<periodDate=YearAgo>}amount)  (YearAgo)

3- Sum(({<periodDate=LastMonth>}amount)  (Last Month)

Please help

[mario-sarkis]

hey Max sorry for disturbing i used it in the expresseion as below

Sum({<periodDate={"$(=num(MonthName(AddYears(max(periodDate),-1))))"}>}amount)

it give me zero so i thinking of greating the field YearMonth in the script. and see.

Thank you alot hope it will work:)

[PrashantSangle]

Hi,

Is it possible to post your app???

Regards