Nov 25, 2020 11:31 AM
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
Solved! Go to Solution.
Nov 26, 2020 04:32 AM
Nov 26, 2020 04:32 AM
Found the answer - use lookup not roll up
Nov 26, 2020 11:31 AM
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.
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: