3 Replies Latest reply on Jul 17, 2015 7:11 AM by Stu412

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

    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