Multiple datatypes for a calculated field

I have created a parameter to switch the view between two values.


Actual vs Index:
Actual is % values, and
Index is decimal points

Is there a way I can dynamically set the data type to show % when view by is Actual and decimal points when view by is Index?


There’s currently no way to achieve this functionality. I’ve tagged this as a #feature-request. Please see this link for a workaround.

1 Like

Thank you for providing the workaround Imran…
Though, I don’t think the workaround is feasible in my case as I have a big table with multiple calculated fields… so, basically I’d have to duplicate the entire table thus affecting the load time after every filter change…