Subtotal is not calculated correcting for one of the custom calculated measure in the OTBI report
I have created a custom OTBI report DPO (Days Payables Outstanding) to look at the average days to pay vendor. The last column is a calculated measure based on the multiplication of the Payment Amount and Days to Pay (payment date - invoice date). I have enabled subtotal for the measures, however, it is not displaying the correct total for this calculated measure. Please advise why subtotal is not calculating correct?
1