Calculate Period Progress.

fredo 

ok no idea Fred no code. I send the DB, first image.

Progress-Cost Report is genereted by a script. Now need the formula to calculate the period progress.

in this DB the 32.54% - 23.81% is the period progress = 9.16%

 On Setting Data Date on green button Update Progress Report Graph.

Each Friday delete both report and generated again with the new data

Fred 

Fred 

Fred too simple but something like this date or week as reference

let date1 := "May 17, 2024";
let percentage1 := 35;
let date2 := "May 24, 2024";
let percentage2 := 42;
percentage2 - percentage1

Fred 

'Earned Value EV' / 'Total Budget BAC' * 100

Fred Hi Fred.

Maybe for this way is more complicate sorry.

I send you a sample table the idea is the same,  need the Period Cost and Period Hours

Example: Cost 24/5/2024 41.258,95 $  Period Cost  = 4302.95 $

                 Cost 17/52024 36.956.00    $    

If I can solve this, I will solve the other.

fredo 

Hi Fred 

Mikro send me a script and works. Is not Cumulative is period spend between weeks.

for share the script. 

let t := this;
let pos := index(((select 'Actual Cost') order by Week).number(id), t.number(id));
let ary := ((select 'Actual Cost') order by Week)[Week <= t.Week].'Actual Cost Week';
if pos = 0 then
    item(ary, pos)
else
    item(ary, pos) - item(ary, pos - 1)
end

Fred