1 of 1 people found this helpful
The calculated field you have created is already aggregated. So that's why its not showing up day by day. To show values on all dates need to remove the aggregation from calculation.
Ex: Calculated Field Without Aggregation
Ex: Calculated field With Aggregation
Thanks. I understand but I don't understand haha. Why does it matter if it's aggregated in terms of whether it shows up for date or just grand total?
Problem is not aggregation, I observed the question incorrectly. Try updating the calculation as below
ZN([Tax])+ZN([Reimbursements])+ZN([Coupon Cost])+ZN([Return Fees])+ZN([Promotions Orders])+ZN([Lightning Fees])
Some times while adding calculations might not give proper results. Make sure you have values on september month as well.