Need to include a figure derived elsewhere in a sub summary total
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.