SSum in Lotus Approach

Tags:
Lotus Approach
Lotus Notes
I'm trying to simply have a 'Running Total' filed in a a worksheet in Lotus Approach. I have a field called 'Amount' and I want the running total right there next to it. I'm trying SSum(Amount) as a formula, but no matter how I write the formula it won't display it there in the worksheet, even when I make two databases joined. What am I doing wrong?


Software/Hardware used:
Lotus Approach
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

It’s in the Help file. I can’t reach it at the moment because Windows has just done an update and wiped out all my winhlp32.dll adjustments.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    According to the Approach PDF , page 465,  that looks right. The only thin is are you sure the fields are defined numeric and how is the summary range defined ?

    Returns the sum of all the values in a number field for a summary
    range of records.

    Format SSum(number field)

    Examples
    SSum(Amount) equals 375, where the Amount field contains 100, 25, 50, and 200 in a summary range of records


    135,495 pointsBadges:
    report
  • VolgaTrader
    OK. My memory has come back.

    Make a field called Balance which summarizes the record, even if all but one of the entries is zero. e.g Balance = Credits-Debits

    Make a summary field for Balance.

    When you create the Summary Field, you define the formula in the Field Definition box. There is a Field Definition tab in the bottom third of the box. Next to it is a Define Summary tab. Click on this.

    You will be asked to select a database within which to summarize records. Do it. Also select the tick box that says, Make Calculation a Running Summary

    From memory. Details may require thought.
    50 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: