Why filter one field in SetAnalysis do not efect sum other field same table?

[yanivvl0]

hi , i have a table (MAIN) of books readers , and i sum the measure (books) ,

i need to sum only those that the indicator (read) = 0 , so i use SetAnalysis : = sum (  {$< read={0} >}  books ) ,

the problem is that when i select read <> 0 it supose to show me NOTHING - BUT i steel see the same numbers !?

another thing , when i use = sum (  if( read=0,  books ) ) it work OK ..

am i missing something ?  THANKS .

[Anil_Babu_Samineni]

Not entirely, But assumption you may try this?

=Sum({$< read={"=Sum(read)<>0"} >} books)

[sunny_talwar]

Try this

=Sum({$<read *= {0}>} books)

[sunny_talwar]

Read about this here:

Implicit Set Operators

[yanivvl0]

hi Anil, that was quik , YEA - its ok , i fix it to Sum({$< read={"=Sum(read)=0"} >} books)   -              the  " = " sign ,

can you tell me whats wrong with my expression ?

THANKS!!!

[Anil_Babu_Samineni · Accepted solution]

Sure, read = {0} returns where read = 0 {That means, It calculates without aggregate} where Sum(read)=0 {It will aggregate each row where cells are common for each orient}

Does this helps?

[yanivvl0]

GREAT HELP!

[yanivvl0]

hi Sunny , very helpfull !!  Always learns professional material from you THANKS!

[sunny_talwar]

No problem at all