Couldn't make the bonus points to show up correctly for each exact user... (Rollup)

Ask for Help
1

Hey guys, I’m sorry I’m new here and it’s probably very simple to do… although still not been able to figure this out - how can I make the bonus points to show up correctly for each partifcular user?

So in the app it’s an online store and when person purchases something then he gets 10% back on his bonus account.

The problem is that Rollup calculates the sum of all orders of all users and gives this 10% again and again to each user.

Tried different filters but still the sum shows up for every user, can’t make it specific for each one…

Thanks a million!!

2

Without knowing what your tables look like, it would be something like: create a multiple relation in your Users table that matches the email address in your Orders table, and then use a rollup through that relation.

2 Likes
3

Thank you @Darren_Murphy !

It worked :slight_smile:

4

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.