Forum Discussion
Why doesn't IFERROR work for PATH errors?
Thank you for the information Anonymous . The problem needs to be solved in two steps. Step one is to make a Parent Search Id using LOOKUPVALUE, as follows:
ParentSearchValue = LOOKUPVALUE ( [Id], [Id], [ParentId] )The LOOKUPVALUE function handles the failures. Step two is to proceed with determining the PATH, using ParentSearchValue instead of ParentId.
Hi Anonymous ,
I think path function analytic on whole field records instead each row. So if these records are not stored as parent child hierarchy, it will return error due to multiple available relationship mapping.
In my opinion, you can add a calculated column to replace error records and use this column in path function.
Regards,
Xiaoxin Sheng
Thank you for the information Anonymous . The problem needs to be solved in two steps. Step one is to make a Parent Search Id using LOOKUPVALUE, as follows:
ParentSearchValue =
LOOKUPVALUE (
[Id],
[Id],
[ParentId]
)The LOOKUPVALUE function handles the failures. Step two is to proceed with determining the PATH, using ParentSearchValue instead of ParentId.