I created a calculated field (Offset credits) in my workbook that works at one aggregation level, but when rolled up to the month, it no longer works? I've tried a couple different things but not sure how to ensure it will work on both views (aggregated to different levels).
I have attached the Tableau packaged workbook showing the data I want at a less aggregated level (daily/gates view). In the Excel file attachment I copied the crosstab and pivoted to aggregate to a monthly view to show what data I would like to see. But in the 2nd tab of the Tableau workbook, you see while the other measures add up correctly, "Offset credits" does not. Can someone please help? I'm not sure what I'm doing wrong!