Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Dear all,
Can you clarify to me what the Negative sign in front of equation means? - =
Many thanks
Cheers
Kezy
Hi,
It means not equals to
Regards
Hi
That means excluding.
Thank you.
Regards
Perhaps, you got this somewhere in set expression.
'-' operator denotes Exclusion.
Example:
sum( {$<Product -= {OurProduct1, OurProduct2} >} Sales )
returns the sales for the current selection, but using an implicit exclusion of “OurProduct1” and “OurProduct2” from the list of selected products.
Yes..
@Tereseco
Thank you so much.
Regards
Kezban also FYI, when used in set analysis like this, the syntax check will highlight this as an error but it is in fact correct and will calculate as expected
Hi,
Ex: All MANUFACTURERs except those whose name begins with ENT
{<MANUFACTURER_LDESC = {"*"} - {"ENT*"}>}
{<MANUFACTURER_LDESC = - {"ENT*"}>}
Ex: All MANUFACTURERs of the selection + those whose name begins with ENT
{<MANUFACTURER_LDESC += {"ENT*"}>}
Ex: All MANUFACTURERs of the selection except those whose name begins with ENT
{<MANUFACTURER_LDESC -= {"ENT*"}>}
Thanks,
AS
Hi Amit,
That is so helpful answer from many perspectives. Thanks a lot.
Regards
Kezy
Pleasure
Thanks,
AS