Page 1 of 1
concat issue
Posted: Mon Mar 10, 2014 3:14 pm
by times29
Hi,
FISCAL_YEAR_NUMBER is decimal 4
JE_PERIOD_NUMBER is decimal 2
i want to get SORT which is decimal 8 as 20141 20142
i am doing as below its just giving me 2014 no period number
FISCAL_YEAR_NUMBER : JE_PERIOD_NUMBER
Any idea what is wrong
Posted: Mon Mar 10, 2014 4:18 pm
by ray.wurlod
JE_PERIOD_NUMBER does not actually have a value?
Show us your actual derivation.
Use the debugger to watch the values on the links.
Posted: Mon Mar 10, 2014 5:20 pm
by chulett
You can only concatenate together string fields.
Posted: Mon Mar 10, 2014 6:06 pm
by ray.wurlod
chulett wrote:You can only concatenate together string fields.
True, but the concatenation operator will automatically cause implicit conversion of its operands to string data type if necessary.
Posted: Tue Mar 11, 2014 2:07 pm
by asorrell
Will it automatically convert decimals to string? I thought only integer could have intrinsic conversion...
I would still try using DecimalToString functions to see if that resolves it...
Posted: Tue Mar 11, 2014 2:18 pm
by chulett
Me, I would never trust anything like this to an implicit conversion... explicit all the way, please. That or look to see if you can use math to effect a solution so no conversion is needed.