MySQL Forums
Forum List  »  Newbie

Different groups, different weight
Posted by: Allan Andersen
Date: October 27, 2023 10:47AM

I'm a heavy Excel and gSheet user. My system is currently based on gSheet and I tried to structure it in a database style. My issue is now that I start to get too much data which slows down everything and creates errors. So I'm trying to educate myself in SQL and moving myself in that direction.

A major issue for me before really taking this step is the below.

I have 3 groups each having a weight of:

Group 1 25%
Group 2 20%
Group 3 55%

So having 100,000$ in total and by that 25,000$ should be in group 1.

On top of that, within each group, there is an A or B. An A should have an allocation of 75% vs a B - and within that group.

How would you do that in that in MySQL? And I would like the value and the in % to be used later on.

Since this is my first post, I'm not sure how to share an example. But I'm very happy for any help and support from you.

Allan, Sweden

Options: ReplyQuote

Written By
Different groups, different weight
October 27, 2023 10:47AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.