# Can a child field be referenced in a formula field on the parent model?

Mark L
Member ✭✭

I have a model with 2 child relationships on them with LIMIT 1 specified.

I'd like to find the greater value of two fields on these 2 child objects and put them into a formula field on the parent object. Is this possible?

How would I go about referencing the child objects in a formula on the parent object?

I'd like to find the greater value of two fields on these 2 child objects and put them into a formula field on the parent object. Is this possible?

How would I go about referencing the child objects in a formula on the parent object?

Tagged:

1

## Comments

If (

{{$Model.YourModelName.data.0.ChildRelation01__r.records.0.field}} > {{$Model.YourModelName.data.0.ChildRelation02__r.records.0.field}},

{{$Model.YourModelName.data.0.ChildRelation01__r.records.0.field}},

{{$Model.YourModelName.data.0.ChildRelation02__r.records.0.field}}

)