Forum Discussion
Solved
MAX of numeric data column in excel pivot table returns 0
There are three data columns in the shared excel file - a Membership ID column formatted as text, a billing number in column Num formatted as text, and a FiscalYear column formatted as numbers. As I...
Column C is all text. Check with ISNUMBER() or ISTEXT().
Change the formula:
=IF(A2 <> "", --LEFT(A2,4),0)
Column C is all text. Check with ISNUMBER() or ISTEXT().
Change the formula:
=IF(A2 <> "", --LEFT(A2,4),0)