Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
You are right. It worked once I fixed the totalling on the varable. I was totalling twice.
bob
>>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
>
>Hi Bob,
>
>Using variables approach should work. Did you verify that you didn't sum twice or something like this? Put the variables close together along with the percentage.
>
>Do you use Print When condition in your details? Where did you put to reset these variables?
Précédent
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