Syntax issue for the beastmode concat ( text column)

Arthi Annadi

I am currently having a column with different data types ( there are null, text, percentage -ve numbers, numeric values ) indicated as text column.

The dataset displays %, -ve values. However , when cards are created, they only display the numbers but not the %. I tried creating beast mode for certain rows, however i get the syntax issue.

How do I indicate %, $ all of them in one column

ColemenWilson

If I am understanding correctly you would do the following:

CONCAT(CASE WHEN fieldThatIndicatesDataType = 'Dollars' THEN '$' WHEN fieldThatIndicatesDataType = 'Percentage' THEN '%' ELSE '' END,`Value`)

Arthi Annadi

@ColemenWilson I am using a text column that indicates everything in the data set such as xx%, $xx. However, it only indicates the numeric numbers in the charts, i tried using beastmode to concatenate the text with $ or % , it throws me a syntax error

Manasi_Panov

Hello @Arthi Annadi,

Why not use the Tooltips function to display % or $ on the cards? Here is more info on this topic:

https://community-forums.domo.com/main/discussion/comment/97940#Comment_97940

Arthi Annadi

@Manasi_Panov It worked. Thank you so much!!