Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Percentage calculation in expression of report
Message
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00588031
Message ID:
00588208
Vues:
29
Hi Nadya,
I've been using CalcRpt as the horizontal sum or each row in the Detail band and also in the Summary band as the vertical sum of the total of that result.
Each row record pertains to an employee and their individual total is calculated in the Detail band and at the end of the report their combined totals are calculated in the Summary band. Would that change what the expression should be?
Thank you!
Max

> Max,

> If this case nCalRpt program even should not be called, since we're not using it anymore.

> Ok, once again:

> 1) Create a variable in Report. Give it another name, say, MyVal
2) Put field1+field2+field3 in the value to store and 0 in Initial value
3) use this variable in detail band in field expression:
iif(myVal+Field2>0,(MyVal/myVal+Field2)*100,0)

> See, if the above will work. If not, try first on a test report, then see, why it is not working on yours?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform