Joined: 30 Jun 2008
Location: United States
Online Status: Offline
Posts: 1
Topic: Count Summary Report Posted: 30 Jun 2008 at 9:03am
I am trying to create a high-level summary report that looks like this:
Total Number of Software Titles ####
# of Software Titles Not Assigned to a CA ####
# of Software Titles Missing Contract Data ####
etc.
How do I set up my report? I can create formula fields that return accurate numbers individually, but when I put them in the same report, they get all messed up. Do I need to use groups, or what is the best way to create a report like this?
Joined: 29 Jun 2008
Online Status: Offline
Posts: 35
Posted: 01 Jul 2008 at 3:27am
I feel Formula fields are better approach but how you are writing makes different try the approach given below Use seperate individual formulas for every condition like below if (condtion ="Assigned") then ( // For getting the right count. 1 ) else ( 0 ); Put this formula in detail field and use Summary field and place the same in Report footer. Create seperate formula for each condition.
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
IP Logged