Forum Discussion

JofrainVisda's avatar
JofrainVisda
Advocate I
5 years ago
Solved

NaN Error when dividing

Hi friends, I know this is not a new issue, but I have tried all the possible solutions that I have seen here and nothing worked. Can someone help me on this? Check my screenshots for the referenc...
Tips and Tricks
  • JofrainVisda's avatar
    JofrainVisda
    5 years ago

    Thank you for all the suggestions guys. I have solved the issue by using the quick measure. It generated this formula
    Productivity Ratio = Divide(Sum([Volume2]),Sum([Headcount2])) which I haven't tried. The SUM function is like converting them into a measure from being a column.

vanessafvg's avatar
vanessafvg
Community Champion
5 years ago

its difficult to understand what is going on there without seeing all the underlying data.

 

divide would be the correct function to use in my opinion, what are you trying to do?   can you provide some sample data?   is volume2 a column or a aggregation?

JofrainVisda's avatar
JofrainVisda
Advocate I
5 years ago

Hello! Well as you can see there are numbers for Volume and Headcount columns. These figures are correct already. But when I divide them, I get the NaN or infinity error. Both of them are calculated columns. Using Divide function gives me incorrect result. It should give me 280 and not 774K.

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    5 years ago

    what is the calculated column code?   there is something underlying going on which is not visible in what you have posted so it would be very hard to tell you .  

    • JofrainVisda's avatar
      JofrainVisda
      Advocate I
      5 years ago

      The Volume and Headcount columns have complicated logic actually. There are combinations of multiple columns. Here is Volume's code

      .
      And here is the productivity2

       

      • v-xiaotang's avatar
        v-xiaotang
        Community Support
        5 years ago

        Hi JofrainVisda 

        Productivity Ratio = Divide([Volume2],[Productivity2])

        try this.

         

         

        Best Regards,

        Community Support Team _Tang

        If this post helps, please consider Accept it as the solution to help the other members find it more quickly.