Tag: Suite analytic Workbook

THREE DECIMAL PLACES IN WORKBOOK

SCENARIO In datasets, quantity fields are automatically rounded to two decimal places when added. For example, if the actual data is “Gold Screw – 0.045 gm” and “Gold Chain – 0.050 gm,” the dataset displays both as 0.05 gm. SOLUTION Apply the formula TO_CHAR({field_id}, ‘9999999990.000’) ‘9999999990.000’ ensures three decimal places are always shown. You can… Continue reading THREE DECIMAL PLACES IN WORKBOOK

Sort Posting Period in Pivot Workbook

SuiteAnalytics Workbook is a versatile analytical tool that enables users to create customized workbooks. It seamlessly combines datasets, tables, pivot tables, and charts into a single platform. Due to the customization options available in workbooks, it’s possible to encounter unexpected behavior when sorting certain fields, such as the Periods field. Scenario: User is having trouble sorting the workbook… Continue reading Sort Posting Period in Pivot Workbook

Data Visualizations of WORKBOOK

Making sense of a workbook’s source data requires the examination of the data from a variety of different perspectives. Accomplished through data summarization, aggregation, and visualization. There are three workbook visualization types: Table Views | Creating a Table View: Click on the Add + icon and select Table. No limit to the number of table… Continue reading Data Visualizations of WORKBOOK