Forum Discussion

JoanCampbell's avatar
JoanCampbell
Frequent Visitor
4 years ago
Solved

If statement to return a numeric value if column contains any value.

This is what I used  Beginner here My formula works : Count of Activity = IF(ISBLANK('Distribution'[ Activity]),"","1")  But it returns a text vaule and I need it to be a numeric value, because I...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Try returning a number instead of a text.

     Count of Activity = IF(ISBLANK('Distribution'[ Activity]),BLANK(),1)

     

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

Try returning a number instead of a text.

 Count of Activity = IF(ISBLANK('Distribution'[ Activity]),BLANK(),1)