Help

Rollup of figures question

Solved
Jump to Solution
852 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Maria
7 - App Architect
7 - App Architect

Hi I am trying to create a breakdown of expenses using rollups but the result is not quite what I want. Can anyone offer a solution please?

Screenshot of what I have so far

payments query

1 Solution

Accepted Solutions
Maria
7 - App Architect
7 - App Architect

Found the answer - use lookup not roll up

See Solution in Thread

2 Replies 2
Maria
7 - App Architect
7 - App Architect

Found the answer - use lookup not roll up

A rollup field could possibly give you the same results. It looks like the main difference is the field formatting. Remember that most fields have formatting options, which can be seen by selecting the “Formatting” tab when editing the field settings.

Screen Shot 2020-11-26 at 11.27.53 AM

If you’re only looking at a single linked record and not aggregating values from multiple linked records, then a lookup might be a better option, but it’s still going to have the same formatting choices as a rollup field. The only possible issue there is that a lookup field creates an array of values (even for a single linked record), so using that elsewhere can be tricky.

Just food for thought on this Thanksgiving Day. :turkey: