Set analysis - Need Help plz

[#1]

Hi All,

I have to exclude abc value which comes in my field (A).

can i know how to do that plz??

thanks

[#2]

try sum({<FieldA-={'abc'}>} amount)

[Anonymous]

i think it should be

sum({<[FieldA]-={'<>abc'}>} amount)

[Anonymous]

hi,

the -= operator in your set analysis should do the trick:

sum({<A-={abc}>}FieldName)

rgds

Artur

[Joseph_Musekura]

Hi,

This should return all values in FIELDA except 'abc' (within a selection)

sum( {$<FieldA = {“*”} – {'abc'} >} Value )

regards,