I am trying to write a rule as follows
dollar(ri!number)>0 for validating the dollar value to be greater than zero. But its always resulting false.
Can someone suggest whats the logic behind it? I had a thought that Appian is considering dollar value as text , and treating text is less than a number.
Discussion posts and replies are publicly visible
Hi,dollar function definition says it return text so you can not compare text with 0 integer value,For above scenario you can use todecimal(dollar(ri!number))>0
if you use tointeger(dollar(0.50))>0 will return false which is not correct
todecimal(dollar(0.01))>0 will return true which is correct