Ifelse error with concate

Question & Answer
, ,
1

image

why this error is coming ???

2

Hi @Siddhi_21 ! Thanks for your question.
I see two erros there, one is regarding the parentheses order and the other is mismatching aggregated fields (sum (Integer)) and non aggregated fields (m_s).
To solve it, considering that m_s is a number and not a string, you could:

ifelse(
max(m_s)=4 or max(m_s)=7,
concat("(", toString(sum(Integer)),")"),
" ")

Let me know if this works for you!
Ana

3

ifelse(

sum({m_s})=4 or sum({m_s})=7,

concat(“(n=” , toString(sum(Integer)), “)”),

sum({m_s})=2,

toString(sum(Integer)),

sum({m_s})=1 or sum({m_s})=3,

toString(sum(DATE2)),

concat(toString(sum(Integer)),“%”)

)

in last concate i want to add a string column as well along with % sign like- in interger its given -34 …sig column- abc
result needed- 34%abc

4

Date -12 digit integer to a date conversion - #11 by Siddhi_21…
arena version for guidance

5

Hi @Siddhi_21,
It looks like you’ve created another post regarding the same topic. Per community guidelines, please try to avoid creating duplicate posts regarding the same question/topic so that it’s easier to keep all relevant information organized for the users aiming to assist.

To limit the number of duplicate responses, I’ll go ahead and archive this post. For all future correspondence regarding this topic, please provide responses on the most current topic, which is linked here.

Thank you!