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)

Sort by

Suggested answer

tanya07 1,638 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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

IB-29041624-0 1,187 Moderator on at

Like (0)

Report
Copy link

Link copied!

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 100,974 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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