Lost Amount (Set Analysis)

[mario-sarkis]

Hey ALL,

here is my question i need to create a line chart that shows me the lost amount monthly which is caculated this way:

(sum({<[Party]={1},[Product/GL]={'Product'}, [RM Finance PeriodDate]={$(=max([PeriodDate]))}>}[Balance USD]) -

sum({<[Party]={1},[Product/GL]={'Product'},[PeriodDate]={$(=num(DayStart(monthend(YearEnd(AddMonths(max([PeriodDate]),-1))))))}>} [Balance USD]))/1000000

The problem is that it shows me only for one month. my requirement is to show the evolution occurs,

Please help anything wrong in my expresssion  ?

[qumniusomnius]

try with adding <= in the date set analysis :

(sum({<[Party]={1},[Product/GL]={'Product'}, [RM Finance PeriodDate]={<=$(=max([PeriodDate]))}>}[Balance USD])

-

sum({<[Party]={1},[Product/GL]={'Product'},[PeriodDate]={<= $(=num(DayStart(monthend(YearEnd(AddMonths(max([PeriodDate]),-1))))))}>} [Balance USD]))/1000000

hope it helps

[mario-sarkis]

hi borja,

Thank you for you reply but it shows me:

"Allocated memory exceeded"

any other Idea ?

[sasiparupudi1]

Please post your application