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!
Saved Search - Custom Formula Error
Trying to divide the Duration Decimal (Hours) by formula created to know how many hours they actually worked based on work factor however it doesnt work. Please suggest how to proceed
Formula - ({durationdecimal}/((40/100) * {item.custitem53}))
Duration Decimal - Gives us value in decimal also, also it has zero also, if someone didnt worked there hours would be zero
{item.custitem53} - Work factor
When running the saved search it gives error, this might be possible because of 0 values under workfactor as zero cant be divided by other values