Tableau is returning an incorrect percentage calculation based on the formula below.
Gross Pay - Month=174735
(SUM([FACS Monthly Collections$].[Monthly Fee]) - SUM([Collector Master$].[Gross Pay - Month]))
/ SUM([FACS Monthly Collections$].[Monthly Fee])
Can you attach a sample/dummy workbook that illustrates this problem?
Just from experience, I'm guessing that the issue is one of aggregation scoping.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...