Expression partially working

[kunkumnaveen]

Hello All,

                Some thing weird is happening with me, expression is working on one row and not working on another row

I am trying to get minimum NUMBER's  Volume ,the expression I wrote is below

  Expression:

  sum({<SCOPE={'YES'},NUMBER={"$(=Num(min(NUMBER),'000'))"}>}total<[MATERIAL CODE],[VENDOR CODE]>VOLUME)

what I suppose to get is for

                                              0002 and 098C              733114 is min volume(I am getting )

for                                          40B  and  061                    473 is min volume (Getting Null)

what am I missing in my expression

Thanks

[sunny_talwar · Accepted solution]

May be this

FirstSortedValue(Aggr(Sum({<SCOPE = {'YES'}>} VOLUME), [MATERIAL CODE], [VENDOR CODE], NUMBER), Aggr(NUMBER, [MATERIAL CODE], [VENDOR CODE], NUMBER))

[shraddha_g]

Saviour stalwar1 as always..