08-02-2018 05:57 AM
I am trying to get a decimal output when using division . both the values are int 30,2830 and obtained by a dynamic count distinct function. when diving(30/2830) both it is showing 0 . unless 0.106 . i tried changing the datatype and even the placeholders but its showing again 0.000000 no values in it . any inputs how to get the
08-02-2018 07:02 AM
Got them , my count ( distinct()) values were int so again converted both the divisor and the dividend to decimal and the final data type for the calculated field to be decimal.
08-02-2018 07:02 AM
Got them , my count ( distinct()) values were int so again converted both the divisor and the dividend to decimal and the final data type for the calculated field to be decimal.
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.