Reputation: 53
How can I solve an error saying "A string is required here"
IF {RECEIVED AMOUNT} <= 0
THEN "CANCELLED"
ELSE {RECEIVED AMOUNT}
Upvotes: 1
Views: 17595
Reputation: 423
Cast {RECEIVED AMOUNT}
to string. Try using the ToText()
function:
IF {RECEIVED AMOUNT} <= 0 THEN "CANCELLED" ELSE ToText({RECEIVED AMOUNT})
Upvotes: 2