Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Change your variable definition
$(expBeløpNyeTilsagn)
sum( {$<ledger_status_group_desc = {'Tilsagn'}, month = {">=1 <= $(=max(month))"}>} allocated_amount_bc * currency_exchange_factor)/ $(vBeløpEnhet)
Use expression as Total in spite of taking sum of rows
See this sample
Hi M,
Thanks for your reply.
What I want is total for current month, not accumulated for months.