When adding a Page Calculated Field, can conditional logic be used to have an if then statement? For instance can something along the following lines be used: IF Field A = “XYZ” THEN 0 ELSE Rec.”Cost Amount”
If conditional logic is an option what syntax is needed? CASE WHEN, IF THEN, etc.
Thank you!
hougaard Answered question 3 days ago
You can use the ternary syntax (The expression verifier in Simple Object Designer doesn’t understand it, but done currently, it will work on BC25+)
https://learn.microsoft.com/en-us/dynamics365/release-plan/2024wave2/smb/dynamics365-business-central/use-ternary-operator-when-coding-al-language
Something like:
a= ‘XYV ? 0 : Rec.”Cost Amount”
cmcnamara Posted new comment 3 days ago
Thank you! I will give that a try!