on 04-09-2009 4:50 PM
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?
Try this
IF ISNULL({CUSTOMER_ORDER.TERMS_DESCRIPTION}) THEN "Net " + totext({CUSTOMER_ORDER.TERMS_NET_DAYS},"#")
ELSE {CUSTOMER_ORDER.TERMS_DESCRIPTION}
Regards,
Raghavendra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
9 | |
9 | |
7 | |
7 | |
7 | |
7 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.