Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Creating a percent at the end of a report...
Versions des environnements
I have a report that totals a group of 7 amounts across the report, then sums all the totals at the bottom. 6 columns total to a category total and the 7th column is a misc. "other". The SQL query that creates the data also creates a "total" column that adds all 7 columns into a total. So I have Colunm1+Column2 + Other etc. = Total. Which when I review the query result it correctly adds all the columns correctly.
What I am trying to do is determine the percent of the total that represents Other/Total at the end of the report. The problem is the percent will not calculate properly for some reason.
I thought maybe what I needed to do was create a variable summing the Other column and also another variable summing the Total column and then take result of these variablesof divide: ie.. other_total / grand_total = (the Percent i'm looking for). But again the division doesn't seem to work to give the correct percentage.
Does anyone know what I might be doing wrong? BTW, the above calculation is occuring in a summary band.
Bob Bartel
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement