Showing All child record items and Totals

Forums vLooup for SharePoint Showing All child record items and Totals

This topic contains 1 reply, has 2 voices, and was last updated by  Alexander Bautz 4 years, 2 months ago.

  • Author
    Posts
  • #7305

    Gilbert Okello
    Participant

    Hi Alexander:
    For vlookup, i have a child list with view fields Title and Amount.
    Under the ‘Action’ section, when i choose SUM, it sums up both the columns. ending with ‘NAN’ for Title (not a number) and the correct total for Amount.

    1. How do I sum only the Amount and not the Title.
    2. How do I include both the child records and their Summations? When I selection the ‘Sum’ action, i only get the totals, not the records.

    • This topic was modified 4 years, 2 months ago by  Alexander Bautz. Reason: Moved to vLookup forum
  • #7311

    Alexander Bautz
    Keymaster

    Hi,
    I can make a modification to vLookup to enable “sum” of number columns. I’ll look at it this weekend and see what I can come up with.

    Alexander

You must be logged in to reply to this topic.