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 som...
Need Help
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.