Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
How do I make the following Set Analysis expression to work?
=Sum( {$< DB={'telcon'}, Part No= - {"ZI","ZP"}> } $(vOpOrdersAmountBalance)) / $(vSalesDivider1)
I need DB= 'telcon' and at the same time Part No <> from 'ZI', 'ZP'
Thanks in advance,
Aldo.
Hi Aldo !
Try something like this:
=sum( {$<DB={'telcon'}, [Part No] -={'ZI','ZP'}>} $(vOpOrdersAmountBalance)) / $(vSalesDivider1)
Note the brackets around Part No and the placement of the minus-sign
/Pär
Hi Aldo !
Try something like this:
=sum( {$<DB={'telcon'}, [Part No] -={'ZI','ZP'}>} $(vOpOrdersAmountBalance)) / $(vSalesDivider1)
Note the brackets around Part No and the placement of the minus-sign
/Pär
Hi,
Does the variable $(vOpOrdersAmountBalance) return a Field Name?
Mike
Yes, it returns a Field Name.
Aldo.
It works,
Thanks,
Aldo.