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.
Which means every month I would have to change the code or rename each Customer Label to match the correct month.
My question is...
Is their a way to get a formula to display a Custom Label?