Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
hi borja,
Thank you for you reply but it shows me:
"Allocated memory exceeded"
any other Idea ?
Please post your application