[image] why this error is coming ???

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 …

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 …

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 nu…

Ifelse error with concate

Q&A

Siddhi_21 September 12, 2024, 3:36pm 4

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

Topic		Replies	Views
Concat two calculated fields using ifelse statement Q&A analysis , error , quick-sight , calculations , Business-Intelligence-Engineer	3	46	September 9, 2024
IF Else statement with Concat Q&A quick-sight , calculations	2	842	October 19, 2022
Calculo con varias condiciones Q&A analysis , error , quick-sight , Business-Intelligence-Engineer	5	280	May 16, 2024
Ifelse error code: Mismatched aggregation Q&A formulas , error , quick-sight , calculations , Business-Intelligence-Engineer	3	173	March 29, 2024
Error in syntax Q&A quick-sight , calculations , Business-Intelligence-Engineer	5	293	December 19, 2023

Ifelse error with concate

Related topics