I have a table in which I want columns containing text to be counted and summed in the calculated field (last column)

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Columns are Error 1, Error 2, Error 3, Error 4. Not all columns have text, some are blank.  I just want a total for those containing text.  I would also like a formula to count those containing specific text, such as, "Billing setup incorrect" and/or "Order total incorrect".

Photo of Selina

Selina

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Try this for the count of non blank text in those 4 fields


Count(

Trim([Error 1])<>"",

Trim([Error 2])<>"",

Trim([Error 3])<>"",

Trim([Error 4])<>"")

The 2nd one would be

Count(

Trim([Error 1])="Billing setup incorrect" or Trim([Error 1])="Order total incorrect",

Trim([Error 2])="Billing setup incorrect" or Trim([Error 2])="Order total incorrect", Trim([Error 3])="Billing setup incorrect" or Trim([Error 3])="Order total incorrect",

Trim([Error 4])="Billing setup incorrect" or Trim([Error 4])="Order total incorrect")

Photo of Selina

Selina

  • 0 Points
Neither one of those worked
Please post your formula and the error message - or are you saying that there was no syntax error but incorrect results?
Photo of Selina

Selina

  • 0 Points
There was no syntax error, no results populated.
I has to work.  I did not test originally, but I just did a test now and it works.  Can see your formula, and can you tell me an example of what is in your data on a record and the results you see?
Photo of Selina

Selina

  • 0 Points
Hello. I have 5 columns.  Each record consists of a. Case Owner b. Error 1 c.Error 2 d. Error 3 e. Error 4.
I'm trying to add a calculated field at the end of a table report that will count the times certain phrases are in each Error column and give me an error total for that record in the last column.
Can see your formula, and can you tell me an example of what is in your data on an example  record and the results you see?
Photo of Selina

Selina

  • 0 Points
The first set of formulas provides produced a count in the field.  The second set of formulas did't produce any results.
I would like the field to be "counted" if only the specified text is there.
Once again, for the third time,  I will ask the same question.

Can see your formula, and can you tell me an example of what is in your data on an example  record and the results you see?
Photo of Selina

Selina

  • 0 Points
forget it- I'll figure it out myself
You know - we all just volunteer our time and talent this forum you know .....  I'm sorry that we could not seem to get on the same wavelength here.  Best of luck to sort it out on your own.