Skip to Content
0
Former Member
Jun 10, 2014 at 04:35 PM

How to make the a field calculating a formula

23 Views

I have a parameter field which take a date range which the user selects and the records are viewed.I need to perform a formula as

Total hours=8*no. of working days.

where the no. of working days should be the according to the date range selected.

Suppose a user selects a date range as 09-06-2104 to 10-06-2104,the no. of working days is 2 and thus the above formula become

Total hours=8*2.

Please suggest me how can i perform this.

Thanks in advance