Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
5 years ago

Has anyone use the rounding option on a data source?

Originally posted by Michael Malandra

6/24/2019

Has anyone use the rounding option on a data source? I have a historical file with fractions of cents that we do not want to load.

Data Sources
  • OSAdmin's avatar
    OSAdmin
    Valued Contributor
    5 years ago
    Originally posted by Joakim Kulan

    Return Math.Round(args.Value, 2)
    I would never recommend using rounding at the source level, as you will end up with numbers that wont match the source if ever you were to use drillback, and as Jessica said, you could end up with mismatching TB.