Using sub filed for > or < in If condition?

[qlikuser222]

Hi Everyone,

I have a requirement where is need to perform calculations based on range of amount. ( < or >=)

PFA attached file which has sample data . I am unable to achieve the results with if condition and using sub field in it.

Please help me understand the error.

Thanks

[Nicole-Smith · Accepted solution]

Try changing you Calc1 calculation to:

if(if(SubField(Range,' ',1) = '<', [Paid Amount] < SubField(Range,' ',2), [Paid Amount] >= SubField(Range,' ',2)), [Paid Amount] * Discount),[Paid Amount] * Discount )as Calc1

I've also attached an updated version of your file.