Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Below SET expression working fine in table .
money(
if([Exec P&L Level] = 's','',
sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} Amount/1000/$(ColumnDim98))
)
, $(vMoneyFormatK_GL))
when i convert to area chart , i get error msg :-
Positive and negative value in chart.
any solution ?
Paul
Hi Paul,
you need to use the Abs() function to solve this issue. It also happens in pie chart.
Abs(Sum(.....)).
My QV doc
Hi All
Can some one advise me on this ?
Paul
Hi Paul,
you need to use the Abs() function to solve this issue. It also happens in pie chart.
Abs(Sum(.....)).
Hi Miguel
Thank you very much. I try with FABS and it work fine now.
Paul