3 Replies Latest reply: Jun 17, 2015 1:49 PM by Sunny Talwar RSS

    Percentage calculation on the speedometer dial chart

      Good morning, my database has the VL_Credito fields, SiglaArea and Curso_Edicao like to with this information generate a speedometer chart and the percentage rate in half; data

       

      VL_Credito SiglaArea Curso_Edicao

      R $ 495,080.00 DG Specialization in Management PUBLIC POLICIES OF CULTURE - 01/2006

      R $ 495,080.00 DG Specialization in Management PUBLIC POLICIES OF CULTURE - 01/2006

      R $ 495,080.00 DG Specialization in Management PUBLIC POLICIES OF CULTURE - 01/2006

      R $ 495,080.00 DG Specialization in Management PUBLIC POLICIES OF CULTURE - 01/2006

      R $ 495,080.00 DG Specialization in Management PUBLIC POLICIES OF CULTURE - 01/2006

      R $ 280,000.00 DCT ENGLISH - 01/2011

      R $ 280,000.00 DCT ENGLISH - 01/2011

      R $ 280,000.00 DCT ENGLISH - 01/2011

      R $ 280,000.00 DCT ENGLISH - 01/2011

      R $ 280,000.00 FAC ENGLISH - 01/2011

      R $ 280,000.00 FAC ENGLISH - 01/2011

      R $ 280,000.00 FAC ENGLISH - 01/2011

      R $ 280,000.00

      FAC

      ENGLISH - 01/2011

       

      My calculation for the chart looked like this:

      Expression: count (VL_Credito) / Count (Name)

      In a field of graph = Text (Sum (VL_Credito) / Count (Name) / Count (Curso_Edicao), '# 0%')

      when generate the graph the percentage value does not work correctly when I select one of SilgaArea