Forum Discussion
Solved
Avoid Summing Values with Duplicate Fields
I've been reading about duplicate values but cannot find what I'm looking for. I'm tracking stats of sales data in restaurants. We have various account types that can pay for checks. I need to tra...
Hi BHigh37 ,
You could use ISINSCOPE() function to set total values.
Here is my test file for your reference.
Hi BHigh37 ,
You could use ISINSCOPE() function to set total values.
Here is my test file for your reference.
Thank you v-eachen-msft , I think this will do it. The test file is a tremendous help. I need to further my understanding of the syntax, but my initial test with my live data is starting to show the results I need.