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...