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

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

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 Узнайте о самых популярных функциях Wrike и советах по его использованию

Nicolas Genibre Wrike Team member Узнайте о самых популярных функциях Wrike и советах по его использованию

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

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]

Вверх
Didn’t find what you were looking for? Write new post