Multiple datatypes for a dynamic calculated field

Cindy · March 21, 2024, 9:43pm

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

Naveed · March 22, 2024, 4:25am

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

Cindy · March 25, 2024, 9:07pm

@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