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!
Dataset Numeric Column not Correct in Workbook
I created a new dataset named "Customer Age" from the DW_NS_X_CAM_CUSTOMEREXTENSION dataset. I removed all but two columns and added two new columns - "Age_months" for customer age in months and "Age_years" for customer age in years. The results when viewed from the dataset are as expected, but when I use the dataset in a workbook, the Age_years gets truncated (e.g. a value of 0.3 is reported as 0.0).
To understand what is going on, I simplified the dataset as follows:
"Age_months" for all rows is set to 4
"Age_years" for all rows is calculated as CAST( Age_months / 12 AS FLOAT )