C
cgcordry
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
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