It works fine for non duplicate values. Does anyone have any ideas?
Bubble lists don’t play nice with duplicate values, but you can modify your expression:
ApexChart B's Points Referral's Points + User's Events:filtered's Points:sum
So you are just getting the first number and adding the sum instead of combining a list then summing everything
If the new item is already in the list, it will not be added.
When your goal is to calculate a sum of a list of numbers, the technique pointed out by @tylerboodman work.
If you need the literal list, including duplicates, such as for calculating a median or working with non-number values in some scenarios, you can try converting the list to text with join with, then adding the additional values using :append, and then converting the string back to a list using :split by.
This topic was automatically closed after 70 days. New replies are no longer allowed.