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!
Adding formula Fields to Reports (total not adding up)
I have created a custom integer field in inventory items that determines the rate at which an item we sell consumes fabric.
eg. ITEM: T112 = FABRIC RATE : 4 (i.e 1 Item consumes 1/4 metre)
In my custom Item report I have created a formula field that divides qty sold/Fabric Rate.
This works great for me, but I can't make the column Total add up properly after clicking 'add grand totals'
Instead of calculating the column total, it is taking the column total of the QTY, and the column total of Fabric rate and dividing the 2 numbers, to give me one number that is useless to me...