Shows a #value! When using calculated fields on a pivot table

Closed

Harold - Mar 11, 2019 at 06:46 PM

Hello everyone

I would like to input a calculated field in the excel pivot table. I have input an formula as if(ERP (Variable)>0, "Yes", "No"). It seems that the value shown on the pivot table was #value!.

However, if I were to use the formula on the raw data, it will meet the command if Yes, No.

Please advise

Shows a #value! When using calculated fields on a pivot table
Calculate due date in access table - Forum - Office Software
Mtu calculator - Guide
Interest percentage to paisa calculator - Forum - Office Software
Scientific calculator - Guide
How to calculate position in excel ✓ - Forum - Office Software

Subscribe To Our Newsletter!