Hi All -
The data in a column in my worksheet is supposed to be zip codes (will be used in power map eventually). However, my formula is not calculating because it is not recognizing the format of the data in the column.
The source data column is formatted as 'Special - Zip Code'. I insert that into a pivot table to get distinct values only. From the pivot table i have copied and pasted into a table in the same workbook. From here I will upload it into the data model in Power Map. However, my formula in the table is not calculating correctly...here it is:
=(COUNTIFS(TWELVE!$A:$A,1,TWELVE!$C:$C,'DETAIL V2'!$AB$2,TWELVE!$S:$S,"A",TWELVE!$BF:$BF,[@ZIPCODE]))
I suspect it has to do with formatting of the zip code. Any suggestions?
Thank you!
The data in a column in my worksheet is supposed to be zip codes (will be used in power map eventually). However, my formula is not calculating because it is not recognizing the format of the data in the column.
The source data column is formatted as 'Special - Zip Code'. I insert that into a pivot table to get distinct values only. From the pivot table i have copied and pasted into a table in the same workbook. From here I will upload it into the data model in Power Map. However, my formula in the table is not calculating correctly...here it is:
=(COUNTIFS(TWELVE!$A:$A,1,TWELVE!$C:$C,'DETAIL V2'!$AB$2,TWELVE!$S:$S,"A",TWELVE!$BF:$BF,[@ZIPCODE]))
I suspect it has to do with formatting of the zip code. Any suggestions?
Thank you!