Skip to Content
author's profile photo Former Member
Former Member

Running total forumla not working

Post Author: Skip

CA Forum: Formula

I am probably missing something pretty simple but can someone tell me why this is not working?

Whileprintingrecords;

numbervar carryover;

if (="C") and (=Date(2006/03/31)) then carryover:=carryover+1;

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2007 at 07:02 PM

    Post Author: yangster

    CA Forum: Formula

    what isn't working in the formula? and where are you placing this formula?where do you want it to evaluate too/display at?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2007 at 04:03 AM

    Post Author: Jagan

    CA Forum: Formula

    If what you've shown is an exact copy of your formula, then I'd guess the paramter to the Date function is not liked. Try Date(2006,03,31) instead. See the help on Date for the arguments.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2007 at 01:40 PM

    Post Author: Skip

    CA Forum: Formula

    This formula is in the detail section. I have another formula in the footer section to display the total

    whilerprintingrecords;numbervar carryover;

    The detail forumla runs, but returns a value of 0.

    I know for a fact there are two records that meet both criteria. Here is an example of one:

    ID Flag Date hours

    1234 C 2006/03/31 7.5

    I'll explain the why for this... in the report I need to calculate the number of incidents for the last firscal year. For this report the FY ends on March 30 so if there is an incident that is a continuation ("C") from the previous FY, I need to subtract it from the total....

    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.