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 derfloh 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. SebaPerez

    Balance

    Yes sorry. The @commitment that appears on my layout is wrong: It is an Summary of @commitment. Now, for each expenditure that I have (which matches with that total commitment) I have to do what I asked in my 1st. post. Sorry for the confusing post, but as I am a beginner it is also difficult...
  2. SebaPerez

    Balance

    The formula for the @commitment is : if {wpo_oc_1.LEDGER} = &quot;CC_BUDGET&quot; and {wpo_oc_1.CLASS_FLD} <> &quot;&quot; then {wpo_oc_1.POSTED_BASE_AMT} The expenditures are database fields. It would be like I have lines of transactions (some of them are expenditure, others are commitments)...
  3. SebaPerez

    Balance

    I have got another problem. I need to make a report concerning a balance. I am using CR8.5 with Access The layout would be like the following: Commitment 13.000 (@commitment) Expenditure 1 1.000 12.000 (@ balance) Expenditure 2 500 11.500 Expenditure 3 1.200 10.300...
  4. SebaPerez

    All the results on my formula are zero

    Okay... I could manage to do that so don't worry. Thanks a lot for the info. Sebastian
  5. SebaPerez

    All the results on my formula are zero

    So just for a lesson-learned issue: What was the problem with my report on the initial steps before you helped me?. What was the difference between having it on the detail section or in the group one?. In the same example now, if I want to apply the same formula to the TOTALS what should I...
  6. SebaPerez

    All the results on my formula are zero

    Mike Thank you very much. It worked perfectly. Sebastian
  7. SebaPerez

    All the results on my formula are zero

    To lbass: No I havn't used any special formatting. To Mike: I have tried what you told me but now instead of having only 0.0 values I have got directly no values. Obviously that last thing changed something but I wouldn't have a clue what to do. What can be possibly happening ? Sebastian
  8. SebaPerez

    All the results on my formula are zero

    Thanks for responding so quickly... I have already tried with mbarron advice and it doesn't work. How can I explain better the situation. The @Expenditure and @Allotment formulas are calculated as follows. I have a field called POSTED_BASE_AMT where I have all the amount and an another field...
  9. SebaPerez

    All the results on my formula are zero

    Hi, I am new using this software and I need urgent help. This is the situation. I have a report with the following field Program Expenditure Allotment Expenditure Rate (A) (D) (A/D) * 100 Program 01 1,946,194.65 0.00 0.0...

Part and Inventory Search

Back
Top