Mike Davies

Follow
  • 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,

    1. Community
    2. Calculations
    3. Holiday Calendar Date Calculation

    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

    1. Community
    2. Calculations

    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
    • 3 followers
    • 3 comments
    • 0 votes

  • Mike Davies created a post,

    IF Calculation

    1. Community
    2. Calculations

    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
    • 2 followers
    • 1 comment
    • 0 votes

  • Mike Davies commented,

    1. Community
    2. Calculations
    3. IF/ Else and Text Calculation

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

  • Mike Davies created a post,

    IF/ Else and Text Calculation

    1. Community
    2. Calculations

    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
    • 2 followers
    • 2 comments
    • 0 votes

  • Mike Davies commented,

    1. Community
    2. Calculations
    3. Text & Number Calculation

    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,

    1. Community
    2. Calculations
    3. Text & Number Calculation

    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,

    1. Community
    2. Calculations
    3. Text & Number Calculation

    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,

    1. Community
    2. Calculations
    3. Text & Number Calculation

    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,

    1. Community
    2. Calculations
    3. Text & Number Calculation

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