Which Formula should be used here?

Hi,

 

I have an issue with the way i want to display data.

                 Balance         Yearly         branch

123              500                1000          1 

456             250               1000           1

789             250                2000         2

 

Current Balance                 yearly goal

       1000                                    4000

I want it to be displayed as the unique goal per branch

Current balance         Yearly

1000                             3000

 

Yearly is being duplicated because the yearly goal is on the row level when it should be at the branch level.

 

When i do group_average(yearly,branch) it displays

750      1000

250    2000

 

Is there a way to solve this? If I was unclear please let me know and I will make it clearer

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi a graz , what does the schema for this query look like?  i.e. what tables are being used and what is the relationship between the tables?  That could help us get a better sense of whats required to solve this one.

    Like
Like Follow
  • Status Answered
  • 2 yrs agoLast active
  • 1Replies
  • 375Views
  • 2 Following