Skip to Content

Grand total of the of Tables

I have a quantity field that displays the number of medication tablets ordered. The field is a string. For each patient it shows how many tablets were ordered. I want to get a grand total of all the tablets. Currently in the report the original report writer put this in a formula to convert the field. Here is the formula. How can I get a total count of all tablets ?

//Some numbers that are stored as string may have leading zeros. Convert these numbers to numeric, then back to string to remove leading zeros. //If the value is alphanumeric, return the original string value rather than converting it to a number.

then ToText(ToNumber({ORDER_MED.QUANTITY}),0)

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Feb 07 at 07:38 AM

    Hi Curt,

    1. Change the code to (or create a new formula):

    IF NumericText({ORDER_MED.QUANTITY})
    Then ToNumber({ORDER_MED.QUANTITY})
    ELSE 0

    2. Go to the Insert Summary option > Select this formula field as the Field to Summarize > Choose 'Sum' as the operation and place it on the Report Footer.


    Add comment
    10|10000 characters needed characters exceeded