Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding two formulas

Status
Not open for further replies.
ggies07

ggies07

Technical User
Jun 27, 2013
40
US
Hi Everyone,

I know I'm not connecting something somewhere, so I need your help.

I have made calculations in each formula and now need to add them together - simple, but not. haha

Here is my code:

Group 1 - student
Group 2 - class
Group 3 - StudentWorkList_.Excuse Type (which is divided by Absent and Tardy)

I have to add the Absences and Tardies together, but for every 3 tardies = 1 Absent.

The calculations come out correctly for each one separately, but I can't add the Absence formula + the Tardy to Absent formula.

Creating another formula with Absent + Tardy to Absent does nothing...


Formulas:

Absent:
if GroupName ({StudentWorkList_.Excuse Type}) = "Absent" then Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type})/76*100

Tardy to Absent:
if GroupName ({StudentWorkList_.Excuse Type}) = "Tardy" then
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 3 then 1 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 4 then 1 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 5 then 1 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 6 then 2 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 7 then 2 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 8 then 2 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 9 then 3 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 10 then 3 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 11 then 3 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 12 then 4 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 13 then 4 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 14 then 4 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 15 then 5 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 16 then 5 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 17 then 5 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 18 then 6 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 19 then 6 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 20 then 6 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 21 then 7 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 22 then 7 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 23 then 7 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 24 then 8 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 25 then 8 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 26 then 8 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 27 then 9 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 28 then 9 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 29 then 9 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 30 then 10 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 31 then 10 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 32 then 10 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 33 then 11 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 34 then 11 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 35 then 11 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 36 then 12 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 37 then 12 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 38 then 12 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 39 then 13 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 40 then 13 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 41 then 13 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 42 then 14 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 43 then 14 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 44 then 14 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 45 then 15 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 46 then 15 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 47 then 15 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 48 then 16 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 49 then 16 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) = 50 then 16



 
Sort by date Sort by votes
where are you placing the absent + tardy to absent formula?
If it is not, try putting the formula in the group 1 student group footer.
 
Upvote 0 Downvote
Problem has been solved. Thanks everyone!
 
Upvote 0 Downvote
Also your formula is way too long. Try this approach:


if GroupName ({StudentWorkList_.Excuse Type}) = "Tardy" then
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) in 3 to 5 then 1 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) in 6 to 8 then 2 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) in 9 to 11 then 3 /76*100 else
if Count ({StudentWorkList_.Excuse Type}, {StudentWorkList_.Excuse Type}) in 12 to 15 then 4 /76*100 else
etc. etc.


Macola Software Veteran and SAP Business One Consultant on Training Wheels

Check out our Macola tools:

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

D
  • Locked
  • Question
Comparing two Date Ranges
Replies
0
Views
177
doodledump
D
socalvelo
  • Locked
  • Question
Date Range Formula - Data from two months ago only
Replies
4
Views
230
pmax9999
pmax9999
Hellak
  • Locked
  • Question
Simple report - filtering by comparing two fields
Replies
1
Views
110
pmax9999
pmax9999
jlr123
  • Locked
  • Question
Dividing Two formulas for Avg
Replies
9
Views
119
lbass
lbass
Fermo Zolli
  • Locked
  • Question
Need help with formulas
Replies
1
Views
76
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top