Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Technical Questions  
Message Icon Topic: Calculate %of Total Post Reply Post New Topic
Author Message

Joined: 17 May 2018
Online Status: Offline
Posts: 22
Quote dax007 Replybullet Topic: Calculate %of Total
    Posted: Today at 5:37am
Hello All,
Happy Friday!
I am trying to calculate % total for one of my report Currently the report is as follow

Dept    1    2    3   4      Total     %total
AA     20   30   10           60        54%
BB     10    5   15   10      40        50%
PreYr                                   AnnualTot
AA     30   10   50   20      110       220
BB     10    5   20   50       80       190

All these Dept and their values are in Detail section.So how do i calculate %Total for each line of department? In above example 54% ( Dept AA currvalue (60) / Dept AA preYr value (110) * 100 = 54%) So if I put develop a formula to calculate %Total and plug it in that column it will display that value for all line item but as I mentioned that needs to be calculated individually for each line item.

Any advice/help?

Thank you...
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.047 seconds.