Joined: 03 Apr 2008
Location: United States
Online Status: Offline
Posts: 2
Topic: If Statement help Posted: 03 Apr 2008 at 3:34pm
Looking to get some help with this report I am working on. Basically what I am trying to do is this, If IncdPers.TYPEOFACTIVITY = Incident Reporting Record and (DistinctCount ({In5basic.INCIDENTNUMBER}, {IncdPers.PERSONLOOKUPID})/DistinctCount ({In5basic.INCIDENTNUMBER}))*100 <= 10% then IncdPers.POINTS = 12.5 else IncdPers.POINTS = 0
I have tryed this many different ways and can not figure out how to make it work. any help would be great.
Joined: 03 Apr 2008
Location: United States
Online Status: Offline
Posts: 2
Posted: 04 Apr 2008 at 5:30am
ok let me try and explain what i am looking to do here.
If the feild IncdPers.TYPEOFACTIVITY = Incident Reporting Record and the (DistinctCount ({In5basic.INCIDENTNUMBER}, {IncdPers.PERSONLOOKUPID})/DistinctCount ({In5basic.INCIDENTNUMBER}))*100 <= 10%
If both of these are true do this
than the feild {IncdPers.POINTS} will = 12.5
if not the feild {IncdPers.POINTS} will = 0
If both are not true then get sum of {IncdPers.POINTS}
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