Small and medium business | Business Central, N...

CalcFormula with if Condition

(2) Share

Report

Posted on by Nishan80

292

HI,

is there a way to use CalcFormula to lookup for values from different table based on the value in another filed or a constant value using IF statement?

Ex :

CalcFormula = if ( field(A) = 1 ) Lookup("Table1".Name where("Record Type" = const("Some Value)

else if(filed(B)=2 ) lookup("Table2.Name where where("Record Type" = const("Some Value) ;

FieldClass = FlowField;

Thanks,

Nishan

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

tanya07 1,638 on at

Like (0)

Report

Hi,

Flowfields cannot be conditioned. You can use other ways to do it.

Thanks,

TK

Was this reply helpful? Yes No
Nishan80 292 on at

Like (0)

Report

what are the other ways ? i can't use "tablerelation" also as a temp table also involves in my use case.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

Maybe you need to generate the sum in a function instead of using a flow field. Sometimes that can be necessary.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (2)

Report

Hi, If you just want to display this data on the page. You can create a variable, display it on the page, then handle this program in the page trigger.

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No