I created a calculated field "A" in a pivot table with the formula=if(hours ge 1,1,0) where hours is another data field. At the detail level it populates the calculated field properly. However, the totals and subtotals show up as 1.

[note: had to use the ge rather than greater than operator in if statement above because it was getting dropped everytime I previewed the post]

thx

cgc