QQ on a formula explanation please: ABS({!$Record.Amount__c}*{!$Record.Currency__r.USD_FX_Rate__c} / {!$Record.Account_Name__r.USD_Valuation_Total__c}) * 100 Could you please assist?
2 answers
Hi @Alex Nis, This formula is calculating the percentage contribution of an objects amount against the Account’s total USD valuation.ABS({!$Record.Amount__c}*{!$Record.Currency__r.USD_FX_Rate__c} / {!$Record.Account_Name__r.USD_Valuation_Total__c}) * 100
Please see the explanation for the each part in the formula,
- Amount__c → The current record amount.
- Currency__r.USD_FX_Rate__c → Exchange rate used to convert the amount into USD.
- Amount__c * USD_FX_Rate__c → Converts the amount into USD value.
- USD_Valuation_Total__c → Total USD valuation from the related Account.
- / USD_Valuation_Total__c → Finds what portion of the total this record represents.
- ABS(...) → Ensures the result is always positive, even if the amount is negative.
- * 100 → Converts the decimal into a percentage.
Example If Amount is 500 , FX Rate is 1.2 and Account Total USD Valuation is 6000 means, It would be,
(500 * 1.2) / 6000 * 100= 600 / 6000 * 100= 10%
So the formula returns 10%
Hope this works for you!
