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 July 2, 2025
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 July 2, 2025
Thank you! I will give that a try!