How to Transform 1/0 to "Yes"/"No"

Avatar
Bri Aiken

Hi there,

Does anyone have a formula for a pivot table for "Is Overdue" column that will allow to transform the 1 value to "Yes" and the 0 value to "No" 

I found online that IF function one works for PowerBI and CASE may work, but I've tried a few but no luck.

Any help is appreciated!

3
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
2 comentários
Avatar
Nicolas Genibre

Hello Bri!

Wrike Analyze does not provide a dashboard function to present text as a formula output. The system only allows for numeric or Null values to be displayed.

Nicolas Genibre Community Team at Wrike Wrike Product Manager Aprenda sobre as funcionalidades e melhores práticas em Wrike com o nosso Treinamento Webinar Online

Nicolas Genibre Wrike Team member Aprenda sobre as funcionalidades e melhores práticas em Wrike com o nosso Treinamento Webinar Online

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
Avatar
Meredith Selden

We need this as well. Mainly due to the Checkbox custom field type as it displays as 0 or 1 on Pivot tables.

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: How to Transform 1/0 to "Yes"/"No"
[this list is visible for admins and agents only]

Alto

Upcoming Live Sessions

Didn’t find what you were looking for? Write new post