Forum Discussion

hectorveram's avatar
hectorveram
Frequent Visitor
3 years ago

Calculate Percentage on values

Hi,   I need a help on calculating % Percentual values from some data filtered into Ballons Options from an excel file (as database)   Is there anyway to include bellot % of the grand total...
Need Help
hectorveram's avatar
hectorveram
Frequent Visitor
3 years ago

Hi,

I have a formula that groups the amount that i show on grafics like this

I want to have percentages of each group of the total sum amount.

 

Thanks

    • hectorveram's avatar
      hectorveram
      Frequent Visitor
      3 years ago

      Hi,

       

      This is how values are grouped

      ConceptoFecha de documentoVencimiento netoDemora tras vencimiento netoCategoria de VencimientoImporte en moneda doc.Moneda del documento

      Concept

      		Document DateDue DateDue DaysAgeingAmountUSD

      Demora

      		1/10/20191/10/20191.102(6) +181 DAYS90,00USD
      Demora13/11/201913/11/20191.059(6) +181 DAYS45,00USD
      Flete / Manifestado28/11/201928/11/20191.044(6) +181 DAYS300,00USD
      Flete / Manifestado28/11/201928/11/20191.044(6) +181 DAYS300,00USD
      Flete / Manifestado18/12/201918/12/20191.024(6) +181 DAYS300,00USD
      Flete / Manifestado18/12/201918/12/20191.024(6) +181 DAYS300,00USD

       

      Highlighted are the groups that i show on Report.

       

      Hope this helps.

       

      Thanks