Forum Discussion
Using PATH(), How Do I Remove Blanks From My Hierarchy Between Levels?
Hello awesome communty! I'm learning the PATH() function, what I'm doing is, I want to create a product category hierarchy, I'm getting a table from Dynamics 365 F&O called "RetailProductHierarch...
Hi I_NeedMorePower ,
I am struggling with the same situation you've described. I'm creating a hierarchy and want to replace the BLANKs, but the expression IF(ISBLANK( doesn't read blank results of PATHITEM as BLANK..
Have you found a solution or any workaround?
All best,
Lukas
Hello lukaszcracow
I think I did...
Haha it was long time a go, I don't remember.
But I will look for the file and see what I did last time and reply back to you.