Skip to Content

Problem summarizing formula using running total (or equivalent formula).

Hi, I am new to this, hope anyone can help. I am using Crystal Report 2013. I have made a formula returning a 0 when a running total is positive and returning a 1 when the running total is negative. I now would like to summarize the 1's on group level, but cannot use the summarize tool. When I make a summarize formula myself, I get an error, that it cannot summarize the field. I have tried to avoid the running total, by making this in a formula as explained on a number of forums, but this did not get me anywhere. The strange thing is, that I can amend the 1's and 0's as number by giving them a digit etc, so the report thinks it is a number, however when I want to make a sum, it is handled as text (boolean). Hope it is clear 😊 what I am looking for.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Aug 22, 2016 at 03:16 PM

    Hi Henriette,

    Could you post both the formula logic and the Running Total logic please?

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.