The Adoption Fee column is Currency, while Dataverse formula columns do not produce the Currency data type and do not support direct use of a currency column without conversion. Microsoft requires the Decimal function to convert a currency value into a supported decimal value before it participates in the formula. The correct expression is therefore `Decimal( ' Adoption Fee ' ) * 0.20`, which returns 20 percent of the current fee as a decimal result. Option C applies Decimal after multiplying the currency column, so it still attempts unsupported direct arithmetic on Currency before conversion. Option D omits the required conversion entirely. Option B is not valid Power Fx syntax for multiplying a column by a percentage. The supplied answer C has therefore been corrected to A. The Deposit formula column should use a Decimal Number result with suitable precision, and because formula columns are calculated from current row values, the deposit automatically reflects later changes to Adoption Fee. Microsoft Learn explicitly documents direct currency-column usage through `Decimal(currency column)` and notes that Currency is not a supported formula-column output type.
[Reference: https://learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns, Study Guide alignment: Build business application logic and automation., , , ]
Submit