Hi All,

I am having a problem with the sum

scenario 1) when i have used

Sum(<Number of Pages(Query 1 with EDC29)> ) Where(=“Concomitant Medications”) in formula field i got the exact result.

where <Number of Pages(Query 1 with EDC29)> is a measure comes from the universe.

scenario 2) now i want to use the formula like:

Sum(<Number of Pages(Query 1 with EDC29)> ) Where(=“Concomitant Medications” And >0)

is giving syntax error:

scenario 3) Now I came to know that in where clause we can only use = operator,

so i have tried if block :=if(=“Concomitant Medications” And >0) then Sum(<Number of Pages(Query 1 with EDC29)> )

else 0

this gives me #computation error so i have tried to include 1) 2) in the table and hide it,but now i not getting the right result it is giving lots of rows 0 and 1 as values in it

so can some one helps me on that why this is happening or any other alternative of this

Thanks

S.R Choudhary

**schoudhary** *(BOB member since 2007-09-21)*