Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
"Save x %" on Item Template?
I've set up a custom item field DISC_PCT of PERCENT type with the default value calculated using the following formula (store value unchecked):
ROUND(({pricelevel1}-{pricelevel5})/{pricelevel1},3)
This custom field is called by item template through javascript to display the % discount on any item that is onsale. Silly issue but I can't get the percentage to simply display in integer format. If I use:
ROUND(({pricelevel1}-{pricelevel5})/{pricelevel1},3) - it displays "46.9%"
ROUND(({pricelevel1}-{pricelevel5})/{pricelevel1},2) - displays "47.0%"
ROUND(({pricelevel1}-{pricelevel5})/{pricelevel1},1) - displays "0.0%"
I simply want to drop all decimal places and round or truncate to the whole integer for display purposes. I tried TRUNC but it didn't work either.