Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

True False column issue

Hello community  -  I have a column that needs to show True if an opportunity from our CRM system is over 365 days old (from today) AND if it is 40% or lower probability.     Then I have  measures wh...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi Anonymous ,

    According to your description, if you want to show blank when the status is False, tweak the formula like this:

    Count of Open Over 365 Under 50=IF(MAX([Open Over 365 Under 50 Column])=False,BLANK(),"Your original code here")
    Value of Open Over 365 Under 50=IF(MAX([Open Over 365 Under 50 Column])=False,BLANK(),"Your original code here")

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi Anonymous ,

According to your description, if you want to show blank when the status is False, tweak the formula like this:

Count of Open Over 365 Under 50=IF(MAX([Open Over 365 Under 50 Column])=False,BLANK(),"Your original code here")
Value of Open Over 365 Under 50=IF(MAX([Open Over 365 Under 50 Column])=False,BLANK(),"Your original code here")

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.