Wildcard usage in report builder


(system) #1
Dan, Wayne's solution will work -- the INT() is in fact Truncate(number,x)
where x is # of decimal places; in your case should be zero. This formula
will round down to the next lower quarter hour (15 minutes).

Truncate( PayHours * 4, 0 ) / 4

If you want to round to the nearest 15 minutes use this:

Truncate(( PayHours + .125 ) * 4, 0 ) / 4

Good Luck
Jim Stetter

-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Friday, August 11, 2000 10:48 AM
To: vantage@egroups.com
Subject: Re: [Vantage] Wildcard usage in report builder


At 10:36 AM 8/11/2000 , you wrote:
>to round payhours to the nearest 15 minute increment. How can a wildcard
be
>used in this formula: IIF(PayHours >= 8.0 and PayHours < 8.25,8.0,0) to
>replace the 8.0, 9.0, 10., and so on?

Multiply by 4, truncate, divide by 4

integer(PayHours * 4) / 4

You'll have to check for the proper name of the INT() function in R.B.

-Wayne




[Non-text portions of this message have been removed]

(system) #2
I am writing a weekly attendance audit report for importing into ADP. I want
to round payhours to the nearest 15 minute increment. How can a wildcard be
used in this formula: IIF(PayHours >= 8.0 and PayHours < 8.25,8.0,0) to
replace the 8.0, 9.0, 10., and so on?

Thanks
Dan Shallbetter
States Electric Mfg.

(system) #3
At 10:36 AM 8/11/2000 , you wrote:
>to round payhours to the nearest 15 minute increment. How can a wildcard be
>used in this formula: IIF(PayHours >= 8.0 and PayHours < 8.25,8.0,0) to
>replace the 8.0, 9.0, 10., and so on?

Multiply by 4, truncate, divide by 4

integer(PayHours * 4) / 4

You'll have to check for the proper name of the INT() function in R.B.

-Wayne

(system) #4
Thank you Wayne works great.

Dan


-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Friday, August 11, 2000 9:48 AM
To: vantage@egroups.com
Subject: Re: [Vantage] Wildcard usage in report builder


At 10:36 AM 8/11/2000 , you wrote:
>to round payhours to the nearest 15 minute increment. How can a wildcard
be
>used in this formula: IIF(PayHours >= 8.0 and PayHours < 8.25,8.0,0) to
>replace the 8.0, 9.0, 10., and so on?

Multiply by 4, truncate, divide by 4

integer(PayHours * 4) / 4

You'll have to check for the proper name of the INT() function in R.B.

-Wayne





[Non-text portions of this message have been removed]