Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: Dividing Calculated Columns in Grp Hdr Post Reply Post New Topic
Author Message
Runner
Newbie
Newbie


Joined: 08 Feb 2013
Online Status: Offline
Posts: 22
Quote Runner Replybullet Topic: Dividing Calculated Columns in Grp Hdr
    Posted: 04 Feb 2014 at 8:44am
I have some payroll data in crystal and am trying to do some calculations. There are calculations for regular/OT/per diem dollars in the Group Header and calculations for regular/OT hours in another Group Header column.

I am trying to take my total dollars and divide by total hours, but keep getting the division by zero. The detail which is a timecard entry has zeros.

Any ideas on a formula to eliminate the error?

Thanks.
Runner


IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 05 Feb 2014 at 5:42am
if sum(OT,groupfield) = 0 then 0 else
sum(regular,groupfield)/sum(OT,groupfield)
IP IP Logged
Runner
Newbie
Newbie


Joined: 08 Feb 2013
Online Status: Offline
Posts: 22
Quote Runner Replybullet Posted: 05 Feb 2014 at 6:08am
Awesome!!!!!!

Thank you very much.
Runner
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.016 seconds.