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