I have 2 reports from 2 different sources. Both reports have the value: sa463w. Report A has it in column A and Report B has it in column B. When I do a COUNTIF on range column A in Report A it returns a 1. When I do it in Report B on range column B it returns a 0. If I copy the value from Report A to Report B THEN Report B COUNTIF returns a 1. Does this have something to do with data types? What do I have to do with Report B to make COUNTIF work like it does in Report A?
Last edited by bishoposiris; 02-22-2014 at 11:00 AM. Reason: Solved
Check for spaces at the end of the string in report B. Countif looks for an exact match - if your cell actually contains "sa463w " instead of "sa463w" then it won't count it, even though they look the same.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
That was it! Report B's values all have spaces after. How can I get around that? Use a wildcard?
Upload your file for quick answer.
Yes:
Formula:
Please Login or Register to view this content.
Problem solved! I used:
and it's working now. Thank you!
Please Login or Register to view this content.
Glad it's solved - thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks