Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

percentage

Regards,
I need to calculate the % COMPLIANCE divided the SALE $ between the BUDGET, that is:
(672.785 / 1.834.360.000) for each month, taking into account the year that I selected.  Thanks

 

 

Need Help

2 Replies

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi Anonymous

     

    What are Presupuesto and Venta? Both measures? How are they calculated? Can you show it? Are they already showing the correct result for the year selected?

    If what you show is a matrix visual with Presupuesto and Venta as measures, then you can easily create another measure for the percentage as:

     

    Percentage = DIVIDE([Venta], [Presupuesto])

    format it as percentage if required  and place it nextto [Venta] in the matrix. 

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi AIB,

      You're right. I'm going to organize what I need and then I'll tell you. I'm new to this topic, what a shame.  Thank you