This discussion is archived
2 Replies Latest reply: Oct 12, 2011 12:17 PM by 762759 RSS

unable to find any sql function like double(XYZ,3 )

627813 Newbie
Currently Being Moderated
Hi ,

we got a formulae where we have to round the value to 3 decimal accuracy tht too twice. but we are not able to find any double function like

= round(round( "Rate" / 3600,3) * ("Time" + "Time2") * Factor / No of Sites,3)

We can use precision also but in the above case we have to create one more measure to consider precision of 3 decimal places

measure 1 = "Rate" / 3600 Precision=3
measure2 = measure1 * ("Time" + "Time2") * Factor / No of Sites Precision = 3

do we have any function to take care of round not to integer but to double value with some precision like sql.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points