why currency sign can display on table 2 but not display on Table 1 with sales by month?

[paulyeo11]

Hi All

This happen only when i display amount by month.

I am unable to figure out where go wrong ?

Hope some one can advise me.

Paul

[paulyeo11]

My QV sample Doc

[sunny_talwar · Accepted solution]

Try this expression instead of using Full Accumulation:

Money(RangeSum(Above(TOTAL Sum(DISTINCT{<year = {"$(=Max(year)-0)"},$(ColumnDim51) ={$(ColumnDim51)}>} Amount*1/ $(Columndim89)/1000), 0, RowNo(TOTAL))), $(vMoneyFormatK))

[paulyeo11]

Hi Sunny

wow , you are good. By the way Can you explain to me why RangeSum(Above will do the trick ?

Paul

[sunny_talwar]

It seems that the inbuilt accumulation removes the formatting from the expression, but with RangeSum(Above()) we are able to keep the formatting intact.

[paulyeo11]

Hi sunny

Thank you for your explanation.

By the way are your job very focus on QV development ? Because I just wonder why you know so much ?

Paul

Sent from my iPhone

[sunny_talwar]

Yes I am working as a QlikView Developer