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!
SuiteAnalystics nest functions - trying to convert NULLIF (a float) to integer
Using SuitAnalytics. Results in dataset of integer values showed tons of zeros. To remove them I created a formula that converted zeros to blank using the NULLIF function. Using the NULLIF function required my formula to be defined as float. All works great as far as the zero suppression, BUT now the integers have 2 decimal places. Tried playing around with CONVERT function, but not working. Should I use some other function to convert them back to integers? Any help is greatly appreciated.