Search results for query: *

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

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

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

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

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

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