G
Guest
I can't get this formula to work for me, i've formatted it several different
ways and still get the general formula error. The formula works fine outside
of the pivot table on the date, just not in the calculated field. Any ideas
please?
none of these work...
=sum('TotalDollarException')/countif('TotalDollarException',"<>0")
or
=('TotalDollarException')/countif('TotalDollarException',"<>0")
or
='TotalDollarException'/countif('TotalDollarException',"<>0")
ways and still get the general formula error. The formula works fine outside
of the pivot table on the date, just not in the calculated field. Any ideas
please?
none of these work...
=sum('TotalDollarException')/countif('TotalDollarException',"<>0")
or
=('TotalDollarException')/countif('TotalDollarException',"<>0")
or
='TotalDollarException'/countif('TotalDollarException',"<>0")