Result not included due to the value '-'

[Anonymous]

I have a column (xamt) that has a value of an amount, a  -0-, a null and sometimes a ' '.   The result of this shows '-' in qlikview.   If I try to select ranges of 0-100 using totusd, some records are not included because the value is '-'.  I

if ((cur)= 'USD',(xamt),((xamt)*(rt))) as totusd

[yura_ratu]

Hi,

Try this:

if (cur = 'USD', RangeMax(0, xamt), RangeMax(0, xamt) *rt) as totusd