If Statement In Pivot Table Calculated Field

    Is it possible to use an "If Statement" in a pivot table calculated field? I always seem to get the false condition even if I believe the statement to be true.

    Code
    if(PivotTableField = 1, "Good", "Bad")


    The code would always return "Bad" no matter if PivotTableField = 1 or not. I saw there was an older thread on the same issue, but nobody ever gave a concrete answer.

    Re: If Statement In Pivot Table Calculated Field


    Can you attach a workbook illustrating the problem? Usually a calculated field returns a value, not text and the formula will refer to the values shown for a field in the data area e.g., the sum displayed, not the individual values being summed.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login