Format Formula

[Former Member]

I have the following formula setup:

IF ISNULL({CUSTOMER_ORDER.TERMS_DESCRIPTION}) THEN "Net " + totext({CUSTOMER_ORDER.TERMS_NET_DAYS})

ELSE {CUSTOMER_ORDER.TERMS_DESCRIPTION}

However when it prints the data to the report the Net_Days has a decimal (Net 90.00). How can I get it to show up as Net 90?

[Former Member · Accepted solution]

Try this

IF ISNULL({CUSTOMER_ORDER.TERMS_DESCRIPTION}) THEN "Net " + totext({CUSTOMER_ORDER.TERMS_NET_DAYS},"#")

ELSE {CUSTOMER_ORDER.TERMS_DESCRIPTION}

Regards,

Raghavendra

[Former Member · Accepted solution]

Perfect! Thanks