Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. oceana6

    if not and startswith formula

    Hey Mike. Thanks for your response. I tried your formula from above, and I still get the same results. My group selection criteria is only based on the org code, so I don't think that is the problem.
  2. oceana6

    if not and startswith formula

    Hi there. Thanks for your response, very much appreciated. However, your solution seems to only give me one account code that starts with 5, rather than all of them? I would like the sum_accounted_budget where all codes start with 5, except 5419.
  3. oceana6

    if not and startswith formula

    Hello. I have a formula that gives me the accounted budget amount if the account code = 5419. Here's what it looks like: if {AF_PERIOD_OPERATING_STATEMENT.ACCT_CODE_KEY} = '5419' then {AF_PERIOD_OPERATING_STATEMENT.SUM_ACCOUNTED_BUDGET} Can anyone help me create another similar formula, that...

Part and Inventory Search

Back
Top