commitment discounts savings view showing wrong data due to unit price = 0

[brunomiguelhenriques]

i have an mca-e agreement and the formula to calculate on demand costs for RI savings is showing me this:

OnDemandCost = if ('CostDetails'[ChargeType]="Usage",'CostDetails'[Quantity]*'CostDetails'[UnitPrice], 0)

However the unit price column comes with 0 for billing events associated to reservations usage:

therefore on demand cost will never be higher then amortized costs.

[flanakin]

Unfortunately, Cost Management does not provide UnitPrice for MCA accounts. Due to this, we cannot calculate on-demand cost for MCA accounts. I can change it to set OnDemandCost to 0 and then update it when Cost Management fixes the bug or leave it as-is so it'll just start working as soon as Cost Management fixes the bug (without you having to update anything). What would you prefer?

[brunomiguelhenriques]

Thanks for the quick feedback Michael!

Currently leaving the OnDemandCost to 0 will not fix my issue because it won´t give the real billing accurate costs unfortunately.

So I assume the best option so far would be to the Cost Management team to fix this issue .

Best regards,

Bruno Henriques

[flanakin]

I'm going to keep this open in hopes that I can spend a little time to try to merge the pricesheet data or find another workaround...