multi sourced material expression

kunkumnaveen — Wed, 05 Jul 2017 08:38:51 GMT

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

Re: multi sourced material expression

prieper — Wed, 05 Jul 2017 09:14:42 GMT

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