Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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