Skip to Content

Total count of Tablets

Ok, that worked. So I put in a sum of formula GetQty but I am getting a total of like 11,000. I just ran the report for one day. What am I doing wrong ? Should I be using a running total or ?

Sorry about that, take out the "qty :=" from the formula and it should work.

-Dell

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Feb 07 at 05:56 PM

    A lot of this depends on how your report is configured. Are you displaying details or just grouped information on the report? Do you have the quantity in the individual rows that you're displaying?

    Please respond as a comment here instead of asking a new question.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

    • Have you validated those numbers against what's in the data? (e.g., put the actual Quantity field next to the number above to validate that you have the correct number?

      I might also try to export the report to Excel and then add up the number column to see whether the total matches what your report is calculating. Given these numbers, I suspect that the totals may be correct.

      -Dell

      Please post any additional info or questions on this topic as comments here.

  • Feb 07 at 07:38 PM

    Thank you, I did validate and the report and it is correct. The report was looking at some meds that should have not been included.

    Add comment
    10|10000 characters needed characters exceeded