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

You don't explain what that 6000000 represents in terms of your data, records and fields. are you trying to reference two different subtotals that are computed via the same summary field but in two different sub summary parts or something else?