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

Formula not showing in Create Running Total Field Dialog

Post Author: pcdelozi

CA Forum: Formula

Greetings! I am attempting to create a running total for particular report fields (actually a formula), however - not all of the FORMULAS that I have created are displayed in the Available Tables and Fields dialog box. I have successfully created a running total on ONE of the FORMULAS - and the next one that I am attempting to create is very similar. Does anyone have any clue as to why all of the Formulas are not displaying? Thanks for any hints!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 11, 2007 at 09:27 PM

    Post Author: synapsevampire

    CA Forum: Formula

    Some formulas can't be used in Running Totals, of course you didn't post your Crystal version or what's in the formula, so you shouldn't expect quality answers. If it isn't first nature to state your software version, and show any formulas you're referencing, please make it so in future posts.

    In general you need to make sure that all rows are accounted for to use them, as in:

    If {table.field} = "A" then1

    Probably won't work.

    If {table.field} = "A" then1else0

    Probably will.

    -k

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 11, 2007 at 09:50 PM

    Post Author: pcdelozi

    CA Forum: Formula

    Sorry for not posting all info you needed! I'm using CR 11.0.0.1282. The FIRST formula that I CAN create a Running Total on is "BIDCOST":

    Local Numbervar BidCost := 0;

    IF {WAS.CHARGE_BRANCH_CD} = "W189" THEN BidCost := {@TOTAL_INITIAL_ESTIMATE_HOURS} * 92.72ELSE IF {WAS.CHARGE_BRANCH_CD} = "W190" THEN BidCost := {@TOTAL_INITIAL_ESTIMATE_HOURS} * 92.84 ELSE IF {WAS.CHARGE_BRANCH_CD} = "W191" THEN BidCost := {@TOTAL_INITIAL_ESTIMATE_HOURS} * 98.61 ELSE IF {WAS.CHARGE_BRANCH_CD} = "W192" THEN BidCost := {@TOTAL_INITIAL_ESTIMATE_HOURS} * 93.15 ELSE IF {WAS.CHARGE_BRANCH_CD} = "W193" THEN BidCost := {@TOTAL_INITIAL_ESTIMATE_HOURS} * 93.80; BidCost

    The SECOND Formula that I CANNOT create a Running Total on - because it is NOT shown in the dialog box as a selection is for the "EAC COST" formula (which is very similar to the one above):

    Local Numbervar EACCost := 0;

    IF {WAS.CHARGE_BRANCH_CD} = "W189" THEN EACCost := {@CALCULATED_EAC} * 92.72ELSE IF {WAS.CHARGE_BRANCH_CD} = "W190" THEN EACCost := {@CALCULATED_EAC} * 92.84 ELSE IF {WAS.CHARGE_BRANCH_CD} = "W191" THEN EACCost := {@CALCULATED_EAC} * 98.61 ELSE IF {WAS.CHARGE_BRANCH_CD} = "W192" THEN EACCost := {@CALCULATED_EAC} * 93.15 ELSE IF {WAS.CHARGE_BRANCH_CD} = "W193" THEN EACCost := {@CALCULATED_EAC} * 103.80;EACCost

    Thanks for any advice!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 12, 2007 at 01:39 AM

    Post Author: yangster

    CA Forum: Formula

    You reference 2 other formulas within your if statement that we have no idea what they do.Please post those too as if the first formula worked for you then there is more then likely something in your @calculated_eac formula that is causing an issue.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 12, 2007 at 02:05 PM

    Post Author: pcdelozi

    CA Forum: Formula

    The formula for @TOTAL_INITIAL_ESTIMATE_HOURS:

    Local Numbervar EstTotal := 0;

    EstTotal := {WAS.FINISHING} +{WAS.SYSTEM_ENGINEERING} {WAS.SOFTWARE}{WAS.PROGRAM_MANAGER};EstTotal

    The formula for @CALCULATED_EAC:

    Local Numbervar CalcEAC := 0;

    CalcEAC := Sum ({TS_CELL.ENTERED_HRS}, {WAS.UDT01_ID}) + {ETC_HOURS.ETC_HOURS};CalcEAC

    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.