Hi,
I created an FlowField which Sums Decimal Values and is displayed on my Card. Now I want to use a Decimal Field on the same Card and Subtract the Value from the FlowField from it. Unfortunately the Simple Object Designer does not recognize my Flow Field. Am I doing something wrong or is this out of the Scope of the Simple Object Designer?
You can use flowfield in a calculated field… Rec.Nameofflowfield
You can get an if expression in… it’s rather weird, and the expression verifier won’t like it (But if correct, it should still publish just fine), go like this:
<if expression>? <true expression> : <false expression>
See here how: https://learn.microsoft.com/en-us/dynamics365/release-plan/2024wave2/smb/dynamics365-business-central/use-ternary-operator-when-coding-al-language
It works great, thank you 🙂
What I could not accomplish was to mark the font as red when my condition is true. It seems the StyleExpr cant be defined solely through my code snippet alone. I assume this is currently out of scope of the SOD?
I forgot the second part of the Question. Is there a possiblity to use an IF Expression for calculated fields? In my case I would like to show a 0 if the return value of my calculation is negative.