Need help with data formats in set analysis formula
I have a set analysis formula that is used to get the trend for last 12 months data.However, I am unable to convert these to number or percent formats. I have field 'data type' which has the data type (number or percent) for the selected KPI. I used the below formula to convert the data formats. But gives me only the un-formatted (only the number format) results.