Add x_TotalSavingsInUsd to the data model

[francesco1119]

⚠️ Problem

We currently have the column x_TotalSavings but that is in the default currency of the customer

🛠️ Solution

We should add this column.

x_TotalSavingsInUsd = Costs[x_ListCostInUsd] - Costs[x_EffectiveCostInUsd]

ℹ️ Additional context

This is a workaround. I think this column should be created at KQL level.

[microsoft-github-policy-service]

Thank you for submitting this issue! We try to respond within 3 business days. In the meantime:

• 📖 Check the troubleshooting guide for common issues
• 💬 Ask questions in Discussions
• 📅 Join our biweekly office hours for live help from the team

[francesco1119]

Ah, and we also need:

x_NegotiatedDiscountSavingsInUsd = Costs[x_ListCostInUsd] - Costs[x_ContractedCostInUsd]
x_CommitmentDiscountSavingsInUsd = Costs[x_ContractedCostInUsd] - Costs[x_EffectiveCostInUsd]

[flanakin]

We should do this as part of the work to support FOCUS 1.3/1.4, since we'll be updating the data model.