Same expression, but to different result because of dimensions

[qvhjenvo]

Hi,

I have 2 tables. See attachment.

The two tables use same same Expression. The different between dem is ledger_no as dimension.

Table1 is a table with ledger_no. And Table 2 has no ledger_no.

The problem is that the total (482,2) in table 2 is wrong.

I can not understand why total in table 2 is differed from total in table 1.

Someone can help me? Thanks in advance. 

[MK_QSL]

Change your variable definition

$(expBeløpNyeTilsagn)

sum( {$<ledger_status_group_desc = {'Tilsagn'}, month = {">=1 <= $(=max(month))"}>} allocated_amount_bc * currency_exchange_factor)/ $(vBeløpEnhet)

[sujeetsingh]

Use expression as Total in spite of taking sum of rows

[sujeetsingh]

See this sample

[qvhjenvo]

Hi M,

Thanks for your reply.

What I want is total for current month, not accumulated for months.