C
Caroline
Hello,
I'm a beginner user and am not sure what I am doing wrong. I have a query
that takes information from other places, including calculations in other
queries such as Expr1: [A]/. When I run the query, all of the correct
results of the calculations show. However, when I make a Pivot Table out of
the query, the results of the calculated fields all turn to zero. When I use
the sum function on other fields, the correct results show. It's only when I
use an expression to do the calculation that all I get in return are zero's.
I've searched Help but haven't been able to find anything.
Thanks in advance.
I'm a beginner user and am not sure what I am doing wrong. I have a query
that takes information from other places, including calculations in other
queries such as Expr1: [A]/. When I run the query, all of the correct
results of the calculations show. However, when I make a Pivot Table out of
the query, the results of the calculated fields all turn to zero. When I use
the sum function on other fields, the correct results show. It's only when I
use an expression to do the calculation that all I get in return are zero's.
I've searched Help but haven't been able to find anything.
Thanks in advance.