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 Rhinorhino 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: *

  • Users: adubrovs
  • Content: Threads
  • Order by date
  1. adubrovs

    % of each record used in running total

    I've created a running total using the 3 formula method to get a sum of a number of records. Is it possible to then calculate the % of each record of the running total? The obvious issue is that Crystal evaluates each row at a time to generate the running total, so when I try to calculate the...
  2. adubrovs

    Outer Joint Issue

    Hi, I'm having trouble with left outer joint. I have two tables, Table 1 and Table 2. I need to compare both to make sure that the a record is in both. If no matching record exists I need to see a blank for that field. I tried using isnull, but i'm not getting the desire result. And left...
  3. adubrovs

    Product of Running Total (rate of return calculation)

    Hi I need to calculate an cummulative rate of return calculation when I only have monthly returns. For example, the table includes the following returns Jan- -0.45% Feb- 1.35% March- 0.25% etc.. The formula is basically [(1+January Return)*(1+Feb Return)*(1+March)]-1. I'm having trouble...
  4. adubrovs

    Comparing data between two reports

    Hi, I'm trying to create a main report that compares a list of records against a list of records created in a sub-report. If the records match, then I do not want that record to be displayed on the main report. From what I understand I need to create a shared variable on the sub-report so i...
  5. adubrovs

    Data Base field not showing up in the Summary

    I created the following formula field that I would like to then sum based on a specific grouping, however, it's not showing up as a field to summarize on. {PF_SECS.MARKET_VALUE} / Sum ({PF_SECS.MARKET_VALUE}, {PORTFOLIOS.PORTFOLIO}) Any help would be appreciated.

Part and Inventory Search

Back
Top