In my previous post, I described the business problem:
Finding filers who made “backwards calculations”. “Backwards” in the sense that they’ve said that us-gaap_ProfitLoss is a calculation parent of the element of us-gaap_NetIncomeLoss. Remember, the former includes income attributable to the noncontrolling interest, and the latter does not. This is backwards because accountants typically subtract us-gaap_NetIncomeLossAttributableToNoncontrollingInterest from us-gaap_ProfitLoss to arrive at a total of us-gaap_NetIncomeLoss. But the above calculation relationship suggests that us-gaap_ProfitLoss is the total. Wrong element.
Confused? I’ll cover that in Part Four. For now, bear with me. Assume it’s “backwards” to go from us-gaap_ProfitLoss to us-gaap_NetIncomeLoss. So, how do we find who’s backwards?
Enter the XBRL-US Database!
To find these filings, I ran this query. I’ve bolded the important parts. Continue reading