Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Table 1 Expression below , Display Amount RM 35K is correct :-
money(
SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=month)"},$(ColumnDim51)={$(ColumnDim51)}>}Amount*1)/$(Columndim89)/1000,
$(vMoneyFormatK))
How to make below expression from chart 1 also display RM 35K same as Table 1 ?
money(
SUM({<year = {"$(=Max(year)-0)"},$(ColumnDim51)={$(ColumnDim51)}>}Amount*1/$(Columndim89)/1000)
,$(vMoneyFormatK))
Now it display RM 140K, Hope some one can advise me.
In my next post , i will post my QV Doc
Paul
May be this;
Money(Sum(DISTINCT{<year = {"$(=Max(year)-0)"},$(ColumnDim51) ={$(ColumnDim51)}>} Amount*1/ $(Columndim89)/1000), $(vMoneyFormatK))
My QV Doc
May be this;
Money(Sum(DISTINCT{<year = {"$(=Max(year)-0)"},$(ColumnDim51) ={$(ColumnDim51)}>} Amount*1/ $(Columndim89)/1000), $(vMoneyFormatK))
Hi Summy
Many thank for your help. Your expression is working fine.
But the chart still have little issue. when i try to display chart for whole year from jan till Dec. the currency sign not work when i set to Org.
Enclosed My QV Doc for your ref
Paul