Forum Discussion

Moniek's avatar
Moniek
Icon for Resolver I rankResolver I
4 years ago

Filter

Hi, I have a table and I want to calculate a % of a value, example, I want % of the total " Omzet" . In my case "Omzet" is 600 = 100%, I want to make a meassure, "Bedrag / Omzet * 100%". There is somtething to do with filter but I don't find the right one yet. Example, "Belastingen" = -400 / 600 = -66,66% instead of 0,00%. Thanks!!

 

 

 

Need Help

6 Replies

  • stefani_vileva's avatar
    stefani_vileva
    Icon for Resolver II rankResolver II
    4 years ago

    Hello,

     

    You can just create a measure:

     

    Measure = DIVIDE(SUM(Bedrag), SUM(Omzet))

    and then just convert this to % and thats it.

     

    I hope this solves your problem.


    Kind regards,

    Stefani

    • Moniek's avatar
      Moniek
      Icon for Resolver I rankResolver I
      4 years ago

      stefani_vileva Thanks but unfortunately that's not the right measure, because "Bedrag" and "Omzet" are already measures.

      • stefani_vileva's avatar
        stefani_vileva
        Icon for Resolver II rankResolver II
        4 years ago

        Can you try with simply using Divide([Bedrag], [Omzet]) ? Or if this is not working, please share your file.