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 commentaires
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 En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online

Nicolas Genibre Wrike Team member En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires 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]

Haut de la page
Didn’t find what you were looking for? Write new post