rangesum(above( Expression get error only on table

[paulyeo11]

Hi All

Below expression give me Balance sheet current liability amount for current month and year which display on Table. ( working fine ).

money(fabs(

Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-0),'YY MMM'))"}

,[Reporting Code] = {

">=70010<=

70070"

     }

     , month = ,year=>}[Amount]/$(Columndim89))/1000)

, $(vCurrencyFormatK))

In order for me to view the last 6 month trend on current liability , i modify the above table by change the diamension from SOURCE to YearMonth. and change the table to line chart.

it display correct. and change the expresison from above to below ( Thank to stefan last time teach me how to make use of rangesum ) :-

rangesum(above(

Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-0),'YY MMM'))"}

,[Reporting Code] = {

">=70010<=

70070"

     }

     , month = ,year=>}[Amount]/$(Columndim89))/1000

,0,rowno()))

Now i wanted to view the Table amount for last 6 month current liability instead from line chart , i need to view from table. i convert the above to table instead of chart.

I get the result wrong , can some one tell me why ?

Paul

[paulyeo11]

Any one can offer me help ?

[orital81]

Hi Paul

When I convert to table I see the same results.

(See attached - table 3). Please clarify - where do you see the gap?

[paulyeo11]

Hi Sir

Thank you very much for your advise. Now i need to move one more step further.

That is i wanted to have table display by SOURCE_GL and display the monthly liability.

Meaning i wanted to view TDSPG and TDSID the monthly liability amount.

you notice that now Table 3 can display individual SOURCE_GL current liability.

But Table 6 display the amount wrong , how to make it display same as table 3.

By the way Table 6 vs table 3 only different is table 6 i Add SOURCE_GL field at diamension.

Paul

[paulyeo11]

Enclosed my QV Doc, hope some one can advise me.