Forum Discussion
ALL Function Not Working
Hi v-huizhn-msft I made a small change to the formula to get it to work. Here is it what it now looks like:
So inside my ALL, I'm referencing the table where everybody's names are consolidated. In my original 'NPS Consolidated' table, people can appear as a Flex or Cobra manager, but they tend to be the same person. I made an additional table called 'NPS Consolidated (2)' specifically for hosting the names of these managers so we can see all records together whether they are Flex or Cobra managers:
So the [LQ NPS] formula comes from my 'NPS Consolidated' table, but I was attempting to use the [Value] column from 'NPS Consolidated (2)' to display my results, thinking it would automatically pick up the ALL function since the 2 tables are related. Once I referenced the table where the names are actually consolidated together rather than where the formula is hosted, it worked fine:
Hi v-huizhn-msft I've since then figured out the issue to my problem. Thanks for reaching out!
Hi Anonymous.
Congratulations, you resolve your issue by yourself, welcome to share your workaround,or you'b better mark your reply as answer. So more people benefit from here.
Best Regards,
Angelia
Hi v-huizhn-msft I made a small change to the formula to get it to work. Here is it what it now looks like:
So inside my ALL, I'm referencing the table where everybody's names are consolidated. In my original 'NPS Consolidated' table, people can appear as a Flex or Cobra manager, but they tend to be the same person. I made an additional table called 'NPS Consolidated (2)' specifically for hosting the names of these managers so we can see all records together whether they are Flex or Cobra managers:
So the [LQ NPS] formula comes from my 'NPS Consolidated' table, but I was attempting to use the [Value] column from 'NPS Consolidated (2)' to display my results, thinking it would automatically pick up the ALL function since the 2 tables are related. Once I referenced the table where the names are actually consolidated together rather than where the formula is hosted, it worked fine: