Averege

[Yan1]

Hello everyone, everything good?

I'm trying to put together a formula but I'm not having success.

I have a spreadsheet which has two tabs (OKR and Activities)

They are talking to each other.

My application works as follows:

the user registers the OKR;
After that, he can register the activities and add the percentage.

What I need help with is so that when he finishes the activities, the average of the activities appears in OKR.

Example:

OKR to be healthier:

Activities: Train more,80%
Eat more healthily,20%

In OKR (already completed) 50% should appear.

How to make this formula?

Hugs

[nicolasfsamaja]

Hey, i am having trouble to underestand. Maybe you can explain a little more 🙂

I guess that solution will be asociated with using app formula with "if" or to show o not "Show if" option.. but give me more info please

[Yan1]

Hello Nicolas!
Thanks in advance for your help!

In the OKRS Menu I have the team's goals, as shown in the print below:

When I click on "Migrate CloudM" (for example) I can add the Key Results:

Note that I have the percentage (already done)

What I need is for the app to calculate the percentages of the key results and show the average. Example:
I have 3 key results with the percentage, 20%, 80% and 100%. I need the OKR to show 66.66%

[nicolasfsamaja]

Ok! 
One more question.
How do you conect the 2 tables?
The main one (OKR) and the other with the Activities.
Is one "child table to the other"?
Show some pics of the data section of your app

[Yan1]

Nicolar,

follow the prints:

OKRS

Atividades

[nicolasfsamaja]

Check if with my answer below you can resolve. I think it will guide you 🙂

[nicolasfsamaja]

If you have 2 tables conected with the Project ID, I think that the OKR will be an App Fomula similar to this:
sum(select(ActivityTable[Achieved%],[Project ID]=[_thisrow].[Project ID]))
/
count(select(ActivityTable[Activity id],[Project ID]=[_thisrow].[Project ID]))

Its like saying, Appsheet: sum please all the % achieved of the activities that have this same project of my OKR. Then for calculating the % , divide for the quantity of activities we have on this proj.

[Yan1]

Nicolas,

I'm just having difficulty swapping fields for spreadsheet columns.

I'll try it here and let you know if I succeed.

Hugs

[nicolasfsamaja · Accepted solution]

Try this one:
sum(select(Atividades[Já realizado],[OKR]=[_thisrow].[ID]))
/
count(select(Atividades[Já realizado],[OKR]=[_thisrow].[ID]))