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

[kunkumnaveen]

when I select only one particular material when it is showing the min volume

[Anil_Babu_Samineni]

May be this?

Sum({<SCOPE = {'YES'}, NUNBER = {'$(=Min(NUMBER))'}>} VOLUME)

[kunkumnaveen]

HI,i tried your expression ,I am getting both the rows zero, i thinking format for NUMBER has to be there

[Anil_Babu_Samineni]

This?

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

OR

Sum({<SCOPE = {'YES'}, NUMBER = {'$(=Min(NUMBER))'}>} TOTAL <[MATERIAL CODE], [VENDOR CODE]> VOLUME)

[shraddha_g]

can you share sample app
?

[kunkumnaveen]

For some reason both your expression are not working I am sharing those two materials and vendors sample file

PFA sample file

[kunkumnaveen]

PFA Sample file

[kunkumnaveen]

I have shared sample data

[Anil_Babu_Samineni]

Might stalwar1‌ has some hands on