ListCost calculation not correct

[DirkBrinkmann]

🐛 Problem

TODO: Based on a customer FOCUS export from end of May with Data from April I noticed that ListCost <> List Unit Price x Pricing Quantity It seems, that the dimension of the Pricing Quantity is not always correct.

👣 Repro steps

None

🤔 Expected

TODO: According to the FOCUS Specification, ListCost = List Unit Price x Pricing Quantity

📷 Screenshots

TODO: If applicable, add screenshots to help explain your problem. Remove if not applicable.

ℹ️ Additional context

N/A

🙋‍♀️ Ask for the community

We could use your help:

1. Please vote this issue up (👍) to prioritize it.
2. Leave comments to help us solidify the vision.

[flanakin]

Discussed this with Dirk offline. This is a Cost Management issue that will be raised with support. We'll keep this open to track it.

[flanakin]

@DirkBrinkmann Any updates on this from support?

[DirkBrinkmann]

@DirkBrinkmann Any updates on this from support?

@flanakin Unfortunately not.

[flanakin]

Turns out the PricingQuantity column in FOCUS datasets was not using the correct value when x_PricingBlockSize was > 1. This issue has been resolved. We recommend re-exporting data for the full year to address this. It will impact anything using PricingQuantity or ContractedCost columns.