Aggr with Max problem - finding the highest different.

[yanivvl0]

hi to all ,

i have an expresion :

= sum (  aggr (  max  (  {$<Subject={1}>}  wanted_num )  ,ID  )  )  -  sum (  aggr (  max  (  {$<Subject={1}>} current_num )  ,ID )  ) 

shortly - i need to find the sums diff between wanted_num and current_num for each ID.

Its OK , but i need also to find the max result of the highest ID , so i use

=  aggr ( max

  (  sum (  aggr (  max  (  {$<Subject={1}>}  wanted_num )  ,ID  )  )  -  sum (  aggr (  max  (  {$<Subject={1}>} current_num        )  ,ID    )  )  )                        , ID)

But it does not work ,

NEED YOUR HELP , THANKS.

[sunny_talwar]

Yup, I saw that below. I am glad you got what you were looking for