I recently started using CDS and Model-Driven apps.
So I have four columns A, B, C, D
Column A value = 10
Column B value = 5
Column C value = A + B = 15
Colum D value = 5% of Column C
Please how do I evaluate Column C and Column D on a Dataverse Table?
There are a few options here.
You can use a Business Rule.
This has some basic mathematical capabilities, and can sum fields together.
You can define column C and D as calculated fields, to do this automatically.
You can use Power Automate to update those fields, with the calculations you discussed. This would mean that you are using regular (non-calculated) fields/columns, which a Flow would set.
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.
We are excited to announce that Demo Extravaganza for 2021 has started!