misterfluff
New Member
- Joined
- Jul 1, 2011
- Messages
- 3
Im trying to do a pivot table in which one column is a calculated field based on non-numeric data (eg the if statement is
If('Question'="why",'Answer',0), where 'Question' and 'answer' are fields), but i just get 0 for everything.
If I change the logical test to a numerical one it works, but then if its a numerical test and the false value is non numeric (say, IF('Number'=5,'Prime',"Gosh") then whenever it is false it just says #VALUE instead of Gosh. yet with the same test, if i swap "Gosh" for a numeric field it works.
What is going on? How do i solve this?
If('Question'="why",'Answer',0), where 'Question' and 'answer' are fields), but i just get 0 for everything.
If I change the logical test to a numerical one it works, but then if its a numerical test and the false value is non numeric (say, IF('Number'=5,'Prime',"Gosh") then whenever it is false it just says #VALUE instead of Gosh. yet with the same test, if i swap "Gosh" for a numeric field it works.
What is going on? How do i solve this?
