Forum Discussion

Antonio195754's avatar
Antonio195754
Icon for Helper IV rankHelper IV
3 years ago
Solved

Using lookupvalue for hierarchy filter

Hello,

 

I'm using the following column formula to return my hiearchy filter 

CHANNEL NAME = lookupvalue('Hierarchy Table'[CHANNEL],'Hierarchy Table'[ID],'B.Opportunity'[ID__C])
 
It works, but what i'm trying to include within the formula is if it returns any blanks, to name those blanks "XYZ" (example)
I'm thinking i have to wrap it around an IF(ISBLANK), but i'm not having any luck with it.  Is this possible to do?
 
Thank you
Need Help
Show and Tell

14 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    Try this

    =if(isblank(lookupvalue('Hierarchy Table'[CHANNEL],'Hierarchy Table'[ID],'B.Opportunity'[ID__C])),"XYZ",lookupvalue('Hierarchy Table'[CHANNEL],'Hierarchy Table'[ID],'B.Opportunity'[ID__C]))

    Hope this helps.