cancel
Showing results for 
Search instead for 
Did you mean: 

Formula not showing in Create Running Total Field Dialog

Former Member
0 Kudos
457

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!

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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!

Former Member
0 Kudos

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