Hi all,
So, I have a large table ("Table 1") with a lot of data. In order to find out which region is sending me data with errors, I have some "if" formulas (eg: =IF(ISTEXT([@[Date of Referral ]])=FALSE,"","1")
I'm giving it a value of 1 if the "Date of Referral" field is not a date. I have values showing up properly, but when I go to make a pivot table to show me what regions are making errors in which fields, it gives me all zeros when I do "Sum" as the pivot table values.
Thoughts?
So, I have a large table ("Table 1") with a lot of data. In order to find out which region is sending me data with errors, I have some "if" formulas (eg: =IF(ISTEXT([@[Date of Referral ]])=FALSE,"","1")
I'm giving it a value of 1 if the "Date of Referral" field is not a date. I have values showing up properly, but when I go to make a pivot table to show me what regions are making errors in which fields, it gives me all zeros when I do "Sum" as the pivot table values.
Thoughts?