Help with calculation field and count of a reference

Answered

Comments

2 comments

  • Rainer Grabowski (FVM)

    Hi Elias,

    you have to use a workaround:
    In App 1, add a calc field that always has the value 1. Like this:

    Field name: Count

    // mention one or more fields that always has a value here: @Title
    1

    In App2 in your calculation field:
    $result = @hours / @sum of count

    Hope it helps,
    Rainer

    1
    Comment actions Permalink
  • Adrien BLAISE

    Let's say you have a "Name" field in your Employes app.

    You could do (in the Leads app) :

    var emp = @All of Name
    var hours = @Hours

    hours / emp.length

    1
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk