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!
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
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!
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.
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