- SAP Community
- Products and Technology
- Technology
- Technology Q&A
- Formula not showing in Create Running Total Field ...

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content

Formula not showing in Create Running Total Field Dialog

Former Member

- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content

on 07-11-2007 9:31 PM

460

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!

- SAP Managed Tags:
- SAP Crystal Reports

Former Member

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content

07-12-2007
3: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

Former Member

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content

07-12-2007
2: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.

Former Member

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content

07-11-2007
10: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!

Former Member

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content

07-11-2007
10: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

Ask a Question

Related Content

Top Q&A Solution Author

User | Count |
---|---|

78 | |

7 | |

6 | |

6 | |

6 | |

6 | |

6 | |

5 | |

5 | |

4 |

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.