how to calculate % progress based on two tables with where condition

What is the best way to calculate the % progress of the activity based on the completed activity task points and total activity task points at the same time get the total number of activity task

I have two tables

activity and task

Activity table

id, name, title,

Task table

id, name, status('In progress','Completed), activity_id, points

For Example

Activity table has this data

Task table has this data

Expected output

where % progress is calculated from total points of completed activity task and the total points of an activity task

What I have tried

On Activity Controller

   public function index()
    {
        try {
            $activities = Activity::with('task')->orderBy('name', 'asc')->get();
            return view('activities.index',compact('activities');
        }
        catch (\Exception $e) {
            return $this->error('Page Not Found');
        }
    }

On view File

percentage() is a helper for % calculation

<table>
<thead>
   <th>id</th>
   <th>Name</th>
   <th>title</th>
   <th>Task</th>
   <th>Points</th>
   <th>Progress</th>
</thead>
<tbody>
    @foreach ($activities as $activity)
       <tr>
          <td class="text-center">{{ $loop->iteration }}</td>
          <td class="text-start">{!! $activity->name !!} </td>
          <td class="text-start">{!! $activity->title !!} </td>
          <td  class="text-center">{!! $activity->task->count() !!}</td>
          <td  class="text-center">{!! $activity->task->sum('points') !!}</td>
          <td  class="text-center">
            <div class="progress">
               <div class="progress-bar bg-success" role="progressbar" 
                    style="width: {{percentage($activity->task->where('status','completed')->sum('points'),$activity->task->sum('points'))}}%"
                    aria-valuenow="{{percentage($activity->task->where('status','Completed')->sum('points'),$activity->task->sum('points'))}}"
                    aria-valuemin="0"
                    aria-valuemax="100">{{percentage($activity->task->where('status','Completed')->sum('points'),$activity->task->sum('points'))}}
                </div>
            </div>
          </td>
      </tr>
   @endforeach
</tbody>

As you can see on the view file is where all the calculations and filtering are done which is not a good practice. I need help

Rather than doing logic inside blade view.

You can move your logic inside Model

at your Activity Model

class Activity extends Model

you can add the following code.

protected $appends = ['progress'];

public function getProgressAttribute(){
    return round(($this->completedPoints() / $this->totalPoints()) * 100, 2);
}

public function totalPoints(){
    return $this->task->sum('points');
}

public function completedPoints(){
    return $this->task->where("status", "Completed")->sum('points');
}

Then inside your blade view you can access to $activity->progress