Hi,
I have a calculated field to present 2 data types. Incremental revenue in Number and ROI in %. How can I set the data type dynamically to show % when user choose ROI and number when user choose incremental revenue?
Any insights woulld be much appreciated.
Thanks,
cindy
Hi,
Create a new calculation field and code like this change your column names.
ifelse((yourcolumn_name = ‘ROI’ ), concat(You number column,%), concat(You number column,M))
Show the column and when you select the ROI/Incremental Revenue, It will show data as per your formate.
Regards
Naveed Ali
@Naveed Thank you! That’s a great workaround!
But I got error messges when I create the ifelse. can you please help?
adding % working fine
But got error message when add this to the ifelse
