HI,
Something weird , I used it last week and all was fine, but now for some reason, the formula completely ignores the right and left Functions
In a Agg model, I have a grouping field (named transactionym. Format of field= text) that return data in this format YYYYMM Example: 202004 (April 2020) and i want to display it in a cleaner format (MM/YYYY)
So i used this formula: RIGHT({{{transactionym}}},“2”) + “/” + LEFT({{{transactionym}}},“4”) with a text return
At first worked well(last week), then tried other formats to test… and this week i come back to put it back in that format (even used page versioning) and nothing i do will amke it work again. The formula keeps returning this format: 202004/202004
So basically ignores the Right and Left Function.
I tried with only left or only right, still nothing
Any ideas?