AnsweredAssumed Answered

Need to include a figure derived elsewhere in a sub summary total

Question asked by Stu412 on Jul 17, 2015
Latest reply on Jul 17, 2015 by Stu412

Title

Need to include a figure derived elsewhere in a sub summary total

Post

I have a summary report which has a group total arrived at by means of a GetSummary statement (for various reasons).

I need this particular result to include a figure derived elsewhere in the DB.  I already have the formula calculated for it but as yet have not managed to include this in my formula and get the correct result.

GetCYTotal - calculated as GetSummary (Total;breakfield)

GetOtherValue - calculated as GetSummary(OtherValue;breakfield)

The breakfields are the same.

I've tried adding the two together in a third formula:

GetThirdFormula - GetCYTotal+GetOtherValue

and I've tried having them both in the same formukla:

GetSummary (Total;breakfield) + GetSummary(OtherValue;breakfield)

Neither gives the correct answer.

However, if I do:

600000 + GetSummary (Total;breakfield)

This results in the correct figure.

So, on the basis I already have the 600000 calculated, how can I included in this calculation dynamically as it's always going to change?

I thought the Let function may be useful, but haven't managed to get that working.

Any help appreciated.

Thanks

Outcomes