Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sum({< Isno={'N'}, [ Name] = {'USA'} >} [ Cost] )
Outcome
$456
here what i did
Sum({< Isno={'N'}, [ Name] = {'USA'} >} [ Cost] ) /1000000
and Number formatting to Money
and Format pattern to $#,##0 M;-$#,##0 M
works perfectly
you give that in the number format rather than on the expression.
give number formatting as Money in qlik sense
Thanks for reply i have use auto format because i want outcome as $61.81M.
if i use money it will be $613654654 something for example , just want to be above format
here what i did
Sum({< Isno={'N'}, [ Name] = {'USA'} >} [ Cost] ) /1000000
and Number formatting to Money
and Format pattern to $#,##0 M;-$#,##0 M
works perfectly