Skip to Content
avatar image
Former Member

if formula

Hi Experts,

I have below requirement wherein I want to discount % only if its less than 100 else word 'foc' should be printed, I tried below

if {Command.DiscPrcnt}= 100 then 'FOC'

else {Command.DiscPrcnt}

it gives message string is required.

Can you advise how to get number and text results in same if statement.

Thansk

Deepak

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    May 12, 2014 at 04:36 AM

    Hi Deepak,

    You can't! You'll need to convert the number to string. Try this:

    if {Command.DiscPrcnt} < 100 then ToText({Command.DiscPrcnt})

    else

    'FOC'

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded