multi sourced material expression

[kunkumnaveen]

Hello All,

                 i am able to achieve my requirement  partially . the thing is i am trying to display only those materials,spend which has supplied by multiple vendors

Expression i tried :

1)Sum({<SCOPE={'Yes'},Material={"=Count(Distinct [VENDOR CODE)>1"}>}SPEND)

All the 100% rows are  single vendor supplied material

so how to not display this 100% rows

PFA...

Thanks

[prieper]

not possible in a tablebox,

you may switch to a straight-table and add an expression like

IF(% <> 1, %)

Albeit it might be better to calculate your percentage on the fly, rather than taking it from the script.

Peter