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))
when I select only one particular material when it is showing the min volume
May be this?
Sum({<SCOPE = {'YES'}, NUNBER = {'$(=Min(NUMBER))'}>} VOLUME)
HI,i tried your expression ,I am getting both the rows zero, i thinking format for NUMBER has to be there
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)
can you share sample app
?
For some reason both your expression are not working I am sharing those two materials and vendors sample file
PFA sample file
PFA Sample file
I have shared sample data
Might stalwar1 has some hands on