Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
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?
Not entirely, But assumption you may try this?
=Sum({$< read={"=Sum(read)<>0"} >} books)
Try this
=Sum({$<read *= {0}>} books)
Read about this here:
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!!!
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?
GREAT HELP!
hi Sunny , very helpfull !! Always learns professional material from you THANKS!
No problem at all