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 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: