Please, I need support to aggr function

[#1]

Hi,

I'm using the aggr function and I don't know if I'm right.

My problem is that I have a table with lines (linea) and profiles (perfil) with their manufacturing forecast (Sum1), but I must divide the forecast between the number of lines of the same profile. I use the aggr function to obtain the number of lines of every profile, but this number only appears in the first row that the profile appears. I need to obtain this number every time.

For example:

I need that  number 4 repeats at lines L3, L4 i L5 to divide 180 every row of MB1881XT profile.

Thanks for your help.

[swuehl]

Try a NODISTINCT qualifier

aggr(NODISTINCT count(distinct Linea), Perfil)

Hope this will help you

Stefan

[swuehl · Accepted solution]

I think this might work as well, without aggr() function needed:

= count(total<Perfil> distinct Linea)

[#4]

Your answers are correct (and really fast). Thank you very much!!!