Dynamic Table: Text in a Calculated Field?

Hi, there!

I created a calculated field, in a dynamic table, to show the words "Yes" or "No" with the folowing formula: =IF('Avg' < 8; "No"; "Yes")
But, it returns an error.

Isn't it possible to show text in calculated fields of a dynamic table?

Thanks!

Try this:


=IF(avg<8,"No","Yes")

I already tried this way, but it doesn't works.
By the way, I use Office 2003 Pro.

Originally Posted by zaphodb2003

Try this:


=IF(avg<8,"No","Yes")

By "dynamic table", do you mean " pivot table"?

Exactly! Thanks!

Originally Posted by arthurbr

By "dynamic table", do you mean " pivot table"?