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)