6 Replies Latest reply on Feb 1, 2019 4:19 AM by koushik.neelakantha

Issue with concatenation

Hello everyone,Please find the attached workbook. when i try to concatenate range of values,i am getting incorrect values. Result should be as expected column.

Example: 1) for low-0 and high 0.3, expected result should be 0-0.3

Regards,

Koushik.

• 1. Re: Issue with concatenation

any help?

• 3. Re: Issue with concatenation

try this:

IFNULL(STR(ROUND(MIN([Low]),1)),'N/A') + ' - ' +

IFNULL(STR(ROUND(MIN([High]),1)),'N/A')

• 4. Re: Issue with concatenation

Hi Mihai, thanks a lot for the reply.

the range under 0.2-0.9 and 0-0.3 should display as 20-90 and 0-30 respectively because we are converting them to % . for others it should not get changed.

Regards,

Koushik.

• 5. Re: Issue with concatenation

thats a different problem, you didn't mention this first time ... I would suggest you parse your data so it's more consistent, mixing percentages and values doesn't help ... however, you could do smth like this:

IF MAX([Low]) <= 1 AND  MAX([High]) <=1 then

IFNULL(STR(ROUND(MIN([Low]),1)*100),'N/A') + ' - ' +

IFNULL(STR(ROUND(MIN([High]),1)*100),'N/A')

else

IFNULL(STR(ROUND(MIN([Low]),1)),'N/A') + ' - ' +

IFNULL(STR(ROUND(MIN([High]),1)),'N/A')

END

1 of 1 people found this helpful
• 6. Re: Issue with concatenation

wonderful thanks a lot Mihai