Could you tell me if there's a setting or formatting option in Dataverse (126.96.36.19990) that will allow decimal places to remain?
My query returned a decimal result in my sql editor tool, but once used in Dataverse I'm losing decimals. I've tried casting using to_number, I changed 1 to be 1.0000, and i also tried rounding to 5 decimal places. But nothing's working, I'm still losing decimal places in output.
Here's the select portion of my query, ROR is the field where I need decimal places.
'M'||to_char(months_between(to_date('2017-06-30', 'yyyy-mm-dd'),effective_date) + 1) as ret_month
,round(1.00000 + one_mon_ror,5) as ROR
Please sign in to leave a comment.