Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks, Marco, I found my mistake.
Sum(Aggr(rangesum(above(if(FPronostico>=FechaPT,Promedio,0),0,Count(FPronostico))),GpoMat,FechaPT,FPronostico))
Why have you got four identical Promedio columns for a start? I can't see the connection between the first and second screenshots.
Because each representing a week is the field fechaPT is a pivot table, is one expression
I must be missing something here. You're just adding 78,363.33 to each previous day's total?
Hi,
can you please post a sample application to test with?
thanks
regards
Marco
Thanks, Marco, I found my mistake.
Sum(Aggr(rangesum(above(if(FPronostico>=FechaPT,Promedio,0),0,Count(FPronostico))),GpoMat,FechaPT,FPronostico))