If statement in pivot calculated field

[PeterHarris]

I am trying to put an if statement in to a calculated field but it is not returning a figure but a #Value or #DIV/0!

Can anyone help?

 

[Fazza]

hi, Peter

Likely best done in SQL. Such as create the pivot table in a file separate from the data & at the first step of the pivot table wizard (ALT-D-P) choose the external data option. Follow the wizard to the end - there will be some minor hurdles if the data doesn't have a normal defined name: can be overcome via PT wizard options, system tables - and then take the option to edit in MS Query. Then the SQL button and edit the SQL to suit. Via the 'open door' icon exit MS Query & complete the pivot table.

SQL will use IIF such as
SELECT IIF(value>0,'positive','not positive) AS [FieldName]

Google will find examples - I've posted many in the past. HTH. Regards