Forum Discussion

LamSar's avatar
LamSar
Helper III
4 years ago

Divide function with incorrect result

Good afternoon,   I have a problem with a formula to calculate a percentage.    See picture below: The red bar shows 11,56%. The pct column in the tooltip is not 11% in total.    This i...
Need Help
Pragati11's avatar
Pragati11
Super User
4 years ago

Hi LamSar ,

 

How is the other measure calculated: [Aantal manco] ?

 

Thanks,

Pragati

  • LamSar's avatar
    LamSar
    Helper III
    4 years ago
    Aantal manco = SUM(Manco[Totaal Manco])
  • Pragati11's avatar
    Pragati11
    Super User
    4 years ago

    HI LamSar ,

     

    Is your custom tooltip using a different percentage calculation? I see in the screenshot, that it uses pct for showing percentages.

    My understanding is your column chart is using pct reden te kort. So it is different to the tooltip.

     

    Thanks,

    Pragati

    • LamSar's avatar
      LamSar
      Helper III
      4 years ago

      No, the column chart also uses the measure [aantal manco]. But per category. 
      And for the tooltip, I need the percentage per subcategory in the category.