search

microsoft / finops-toolkit

Tools and resources to help you adopt and implement FinOps capabilities that automate and extend the Microsoft Cloud.
https://aka.ms/finops/toolkit
MIT License
305 stars 106 forks source link

ListCost calculation not correct #727

Closed DirkBrinkmann closed 3 days ago

DirkBrinkmann commented 5 months ago

🐛 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. image

ℹī¸ 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 commented 5 months ago

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 commented 1 month ago

@DirkBrinkmann Any updates on this from support?

DirkBrinkmann commented 1 month ago

@DirkBrinkmann Any updates on this from support?

@flanakin Unfortunately not.

flanakin commented 3 days ago

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.