UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Cumulative Percentage, Access 2013    
 
   
hatmal
post Aug 14 2019, 07:24 AM
Post#1



Posts: 10
Joined: 18-January 15



i had two field CummulativeLate (min): Val(Nz(fnCummulativeLate([id],[uotono]),0))



and

cummulativeealy(min): Val(Nz(fnCummulativeealy([id],[uotono]),0))

and this fields as you know are cumulative per employee

i need new filed with name percentage deducted

this field with formula as attached excel
Attached File(s)
Attached File  sys.zip ( 63.5K )Number of downloads: 2
 
Go to the top of the page
 
RJD
post Aug 14 2019, 07:29 AM
Post#2


UtterAccess VIP
Posts: 10,028
Joined: 25-October 10
From: Gulf South USA


Hi: Looks like a bad attachment file. Could you try to zip and post the file again?

Thanks,
Joe

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 
hatmal
post Aug 14 2019, 08:14 AM
Post#3



Posts: 10
Joined: 18-January 15



hi RJD file attached

Regards

This post has been edited by hatmal: Aug 14 2019, 08:14 AM
Attached File(s)
Attached File  archive.zip ( 110.69K )Number of downloads: 3
 
Go to the top of the page
 
RJD
post Aug 14 2019, 11:43 AM
Post#4


UtterAccess VIP
Posts: 10,028
Joined: 25-October 10
From: Gulf South USA


Hi: I am not at all sure I understand this yet. I will have to look at this later, or perhaps someone else has time to study this and suggest a solution.

HTH
Joe

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 
RJD
post Aug 14 2019, 05:58 PM
Post#5


UtterAccess VIP
Posts: 10,028
Joined: 25-October 10
From: Gulf South USA


Sorry, but even after studying your post and the attached spreadsheet, I am unable to understand the data and the logic to apply. I will put out a call to the VIPs and see if anyone else can assist you.

Sorry I am not able to help.

Regards,
Joe

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 
hatmal
post Aug 14 2019, 07:02 PM
Post#6



Posts: 10
Joined: 18-January 15



THANKS JOE

any help please
This post has been edited by hatmal: Aug 14 2019, 07:03 PM
Go to the top of the page
 
hatmal
post Aug 15 2019, 04:15 AM
Post#7



Posts: 10
Joined: 18-January 15



new file attached with more Explain in excel sheet to


please help
Attached File(s)
Attached File  Files.zip ( 152.53K )Number of downloads: 3
 
Go to the top of the page
 
projecttoday
post Aug 15 2019, 05:30 PM
Post#8


UtterAccess VIP
Posts: 10,974
Joined: 10-February 04
From: South Charleston, WV


How do you calculate 10%? 45%? 75%?

--------------------
Robert Crouser
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    23rd September 2019 - 02:07 AM