-
1. Re: Issue with concatenation
koushik.neelakantha Feb 1, 2019 2:37 AM (in response to koushik.neelakantha)any help?
-
2. Re: Issue with concatenation
Mihai Constantinescu Feb 1, 2019 3:21 AM (in response to koushik.neelakantha) -
3. Re: Issue with concatenation
Mihai Constantinescu Feb 1, 2019 3:32 AM (in response to Mihai Constantinescu)try this:
IFNULL(STR(ROUND(MIN([Low]),1)),'N/A') + ' - ' +
IFNULL(STR(ROUND(MIN([High]),1)),'N/A')
-
4. Re: Issue with concatenation
koushik.neelakantha Feb 1, 2019 3:42 AM (in response to Mihai Constantinescu)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
Mihai Constantinescu Feb 1, 2019 3:59 AM (in response to koushik.neelakantha)1 of 1 people found this helpfulthats 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
-
6. Re: Issue with concatenation
koushik.neelakantha Feb 1, 2019 4:19 AM (in response to Mihai Constantinescu)wonderful thanks a lot Mihai