Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=count({$<[FIELD1]={"Sales"}>} [FIELD2])
I would like to count, using set analysis, excluding FIELD1="Sales"
would be something like this:
=count({$<[FIELD1]<>{"Sales"}>} [FIELD2])
It seems that using "< >" operators in setanalysis is not property...
Tks!
hi try this:
=count({$<[FIELD1]-={"Sales"}>} [FIELD2])
regards
count({ $<FieldName= (FieldName - {"CustomerId"} ) >} FieldName)
It perfectly answered my question!
Tks