if formula

[Former Member]

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

[abhilash_kumar · Accepted solution]

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

[Former Member · Accepted solution]

Hi Abhilash,

Thanks for instant reply, I tried above but it returns on 'FOC'  and Discount less than 100 is shown blank.

Please advise.

Thanks

Deepak

[Former Member · Accepted solution]

Hi Abhilash,

Thanks it worked now.

Thanks

Deepak

[abhilash_kumar · Accepted solution]

Could you post a screenshot of the Preview Mode with both the {Command.DiscPrcnt} field and the formula field placed beside each other?

-Abhilash