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!
How to create a custom label with a formla?
Hello,
I was hoping some one could help me out on a Saved Search I am trying to create.
I have two decode formulas which return a Sales Order for YTD & MTD. I also want to have a breakdown for each month in the current year. To do this I am starting with the current month and subtracting 1 to get the month before, -2 for the month before that, and so on. I want to label each of these columns with the appropriate months label.
But... when the month changes my current month formula and my -1, -2 is pointing to a different month and doesn't coincide with the Custom Labels.