Jump to content

Twizzle

Newbies
  • Content Count

    3
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Twizzle

  • Rank
    newbie

Profile Information

  • Title
    Chairman
  • Industry
    Finance
  1. Hi I just need some help with the correct syntax for calculating an average in a Sub Summary report. I have a database with share parcels in it & each of my companies holdings in other companies are recorded there. Now I'm reasonably used to Summary & Grand Summary Totals in an FM report and for me they have usually been a mere Total or Sub Total of a figure but I am having difficulty in getting an average price to appear correctly in a Sub Total. The Grand Total Average 'share price' appears correctly in my reports but no matter what syntax I try I can't get it to appear correctly in the Sub Total. The field 'AverageEntryPrice' is derived by Type: Calculation. Unstored,=Bvalue Total/Total Held. This works well in the Total part of the report but whatever I try in the Sub Total section I can't get it to appear correctly. Currently in the Sub Total section I have "Sub Tot Avge Entry Price" Type: Summary Options: Total of AverageEntryPrice (running with restart), when sorted by Invest Converted::BO. So I thought this should give me the average price that each of my companies pays for shares in other companies but it does not work. Of course if I do a report for each of my companies individually I can get the Avge price for that companies holdings as it appears in the Grand Total section but it would be good to get all 3 companies in the one report. Has anyone go any suggestions.
  2. Hi Cobalt Sky I just need some help calculating an average in a Sub Summary Report. I have a database with shares in it & each of my companies holdings in other companies are recorded there. Now I'm reasonably used to Summary & Grand Summary Totals in an FM report and for me they have usually been a mere Total or Sub Total of a figure but I am having difficulty in getting an average price to appear correctly in a Sub Total. The Grand Total Average 'share price' appears correctly in my reports but no matter what nomenclature I try I can't get it to appear correctly in the Sub Total. The field 'AverageEntryPrice' is derived by Type: Calculation. Unstored,=Bvalue Total/Total Held. This works well in the Total part of the report but whatever I try in the Sub Total section I can't get it to appear correctly. Currently in the Sub Total section I have "Sub Tot Avge Entry Price" Type: Summary Options: Total of AverageEntryPrice (running with restart), when sorted by Invest Converted::BO. So this should give me the average price that each of my companies pays for shares in other companies. Thanks in advance.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.