Chris Wood

  • Total activity 17
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 0
  • Subscriptions 7

Activity overview

Latest activity by Chris Wood
  • Chris Wood created a post,

    Extracting Text from regular email format

    I am trying to get the correct formula to extract the highlighted text data below - the format of all emails is the same but of course the SKU and the Quantitiy numbers can vary 0 - 99 but SKU is c...

  • Chris Wood commented,

    Hi Rainer,   I do use globiflow, Can you confirm what you think the easy solution is for the rolling basis?   thanks again, chris

  • Chris Wood created a post,

    Calculating Total Sales Based on Date

    I want the below formula to return the sum of ex VAT total field for any sales that fall between the two dates from APP A and the result is put into a field in APP B.   Ideally I would have it so t...

  • Chris Wood created a post,

    Generating Statement with a Calculation

      Hi Rainer     Following on from this I am now trying to create a similar thing for outstanding supplier invoices. I am using the following calculation but as you can see the result is returnin...

  • Chris Wood commented,

    Hi Rainer     Following on from this I am now trying to create a similar thing for outstanding supplier invoices. I am using the following calculation but as you can see the result is returning as...

  • Chris Wood created a post,

    Undefined result on Java

    I am returning a result undefined instead of the category result - there are 4 options all of which are single choice and originally they did pull through correctly but have since started returning...

  • Chris Wood commented,

    Hi Rainer thanks for this. it works to a certain degree. It still displays all those invoices that have a zero amount as the outstanding amount. I want to only display those that have an outstandin...

  • Chris Wood commented,

    Quick question - I have created a table that shows all the sales made to a client but really I just want it to show those that have a value greater than zero in the outstanding field. Is this possi...

  • Chris Wood created a post,

    Generating Account Statements for Clients

    I have two apps - one for sales and one for clients. I want to generate a statement of account for the unpaid invoices that are related to the individual clients. Currently I can generate a stateme...

  • Chris Wood created a post,

    Java Date/Sum

    I wish make a caculation field that uses the following If/Else style function. If the Date field is not set/is blank then add 2 numeric fields together otherwise return zero/dont do anything Is th...