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. GeorgeOrwell1984

    Variable for WACD

    LB and All WACD Solution I'm sure LB can tidy this up to make more sense and I think I have over done or doubled up on some of the variables. BUT it now works! If your used to using Cyrstal and fiddle around a bit I'm sure you'll get it working the same as I have using some or all of below...
  2. GeorgeOrwell1984

    Variable for WACD

    LB Solved it I believe. Your comments helped me to resolve in a new set of eyes kind of way. Going to tidy it up and then will post solution in the spirit of the forum Rgds George84
  3. GeorgeOrwell1984

    Variable for WACD

    LB Further info -£59,400,000.0000 -£2,000,000.0000 -£14,000,000.0000 -£12,000,000.0000 -£8,000,000.0000 last detail line of group -£95,400,000.0000 total Group 15-04-2017 £0.0000 -£14,482,801.3463 -£32,104,800.0000 -£600,000.0000 -£22,848,961.0380 £0.0000 -£134,700,000.0000...
  4. GeorgeOrwell1984

    Variable for WACD

    LB Thanks for your help. I kinda understand what you mean in your last statement. I have used Crystal for years but have never had any formal training in it....so I'm a bit more trial an error than logical progression in the order of the report build up. Whilst I have used Crystal for some...
  5. GeorgeOrwell1984

    Variable for WACD

    Ibass Thanks for the Response I am not able to use the summary function because one of the primary parts is a variable from a sub report. 10,000.00 * 1.5 = 15,000.00 The 10k comes direct from a DB field...the 1.5 is a SharedNumbervar from a sub report hence I can't use the summary function...
  6. GeorgeOrwell1984

    Variable for WACD

    I'm trying to write a weighted average cost of debt report. This is very easy to calculate in excel using: sumproduct(a1:a15,b1:b15)/c15 or as per example below I have the Values and multiplying factor coming in on the details lines and have used a simple formula (which I will call Weighted...

Part and Inventory Search

Back
Top