# Mike Davies

• Total activity 28
• Last activity
• Member since
• Following 0 users
• Followed by 0 users
• Votes 0
• Subscriptions 8

## Activity overview

Latest activity by Mike Davies
• Mike Davies commented,

Thanks Rainer, I will have a look for working day calc. Please could you assist with bank holiday calculation for the U.K.?

• Mike Davies created a post,

### Holiday Calendar Date Calculation

Hello, Please could somebody advise if it is possible to calculate the number of days between two dates (start date and end date) excluding weekends and bank holidays? Many thanks Mike

• Mike Davies created a post,

### IF Calculation

Hello, I was hoping for some help with an if calculation. I have a very simple calculation as per the attached. I now want to expand on this IF relationship field contains "LS LED Skirting" then su...

• Mike Davies commented,

Thanks Rainer!! Step 1 was good advise and step 2 solved my problem :D.

• Mike Davies created a post,

### IF/ Else and Text Calculation

Hello, I am trying to create a variable text string but not having any luck. I have attached my terrible example of trying to manipulate an existing calculation. The calculation is taking text from...

• Mike Davies commented,

Thanks Rainer, this is now working. One last question, as these are text fields they cannot be used in a report calculation is there any possibility for the whole output to be converted to number f...

• Mike Davies commented,

Hi Rainer, Could you please provide an email address for me to send this to. I don't want to post this online as it will include Company content. Thank you. Mike

• Mike Davies commented,

Hi Rainer, Unfortunately this has not worked either. It is outputting £ 0.00 for both VAT and GROSS. Really appreciate the assistance and hope you can help resolve. Thanks Mike

• Mike Davies commented,

Hi Rainer, Having input the below calculations for VAT *TEST & GROSS Total *TEST* these are both returning £ NaN. Is there anything you can think of why these would not be working? Thanks Mike

• Mike Davies commented,

Hi Rainer, Thanks again for your help. As I am an extreme novice with javascript. I am struggling to understand how I incorporate this into our calculation. Does this combine with my existing calcu...