Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What is the expected value when you select one of SilgaArea? In addition are you getting correct results when nothing is selected?
To me it seems that Expression: count (VL_Credito) / Count (Name) will always give you 1 unless you have a null value for one of those.
Please provide more details to help you resolve the issue.
Best,
Sunny
VL_Credito the field is decimal , the SilgaArea and Curso_Edicao are text fields , I want Vazer the sum of VL_Credito divided by SiglaArea which are three DCT , DG and FAC , by the time I select a destars SiglaAreas the clock give me the percentage value by SiglaArea said
still not 100% certain, but see if this gets you to where you want to go:
=Sum(VL_Credito)/Count(DISTINCT SiglaArea)