Range Sum

[Anonymous]

Hi, every one !

Hi all,
I need help with this expression , my problem is that,  is not adding the Promedio , someone has any idea how to solve it.

rangesum(above(sum(if(FPronostico>=FechaPT,Promedio)),0,731))

this is what I want to accomplish for every one column.

Thank you a lot.

[roger_stone]

Why have you got four identical Promedio columns for a start? I can't see the connection between the first and second screenshots.

[Anonymous]

Because each representing a week is the field fechaPT is a pivot table, is one expression

[roger_stone]

I must be missing something here. You're just adding 78,363.33 to each previous day's total?

[MarcoWedel]

Hi,

can you please post a sample application to test with?

thanks

regards

Marco

[Anonymous · Accepted solution]

Thanks, Marco, I found my mistake.

Sum(Aggr(rangesum(above(if(FPronostico>=FechaPT,Promedio,0),0,Count(FPronostico))),GpoMat,FechaPT,FPronostico))