Subtotal is not calculated correcting for one of the custom calculated measure in the OTBI report
Summary:
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 measure, however, it is not displaying the correct total for this calculated measure. Please advise why subtotal is not calculating correct?
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
24B
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0