Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
FirstSortedValue(Aggr(Sum({<SCOPE = {'YES'}>} VOLUME), [MATERIAL CODE], [VENDOR CODE], NUMBER), Aggr(NUMBER, [MATERIAL CODE], [VENDOR CODE], NUMBER))
Saviour stalwar1 as always..