Why is the beast mode that calculates a percentage wrong in total row but correct in regular rows

user03579
user03579
in Dataflows

As seen in the attached file, the first column is numerator, second column is denominator, the third column is a beast mode: numerator/denominator. There's no aggregation on any data. The calculation is correct for each record but when it comes to total row it's wrong. If i change the beast mode to sum(numerator)/sum(denominator), then the beast mode would validate but i get a "An issue has occured during processing. We are unable to complete the request at this time" error and no data is displayed. What am I doing wrong?

ss.JPG 24.1K

Comments

  • Property_Ninja
    Property_Ninja

    Hello,

     

    Do you mind sharing what your beastmode looks like currently?

     

    Thanks,

     

    Brian


    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.
  • Unknown
    Unknown

    ifnull(sum(numerator)/nullif(sum(denominator),0),0)

    however i created a new beast mode with the same code and it worked.

     

Categories