Skip to main content
DD-AUD-001-Q014 Easy

Manual credits to revenue

Manual journals are the lines whose SourceCode is "MJ". A journal is one JournalNumber; count journals once, not per line. How many manual journals credit an account whose AccountType is "Revenue"?
Expected
One whole number · KPI card
Tables
FactJournalLines, DimAccount · columns
  • FactJournalLines
  • DimAccount
  • AccountCode
  • Credit
  • SourceCode
  • AccountType

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us