entity\sumRelated( ) does not work?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • chrisjiang
    Member
    • Dec 2018
    • 88

    entity\sumRelated( ) does not work?

    After some learning and exploration, I learned the formula only works with record links....

    Not fully understand though.

    Please forget the following...... Thanks.

    Hi,

    I have upgraded to 5.9.3.

    I have the following formula and found it not working:

    income = entity\sumRelated('invoices', 'amount', 'reportFilter5efdc66f6ac9db883');

    "income" is a field of an entity called "Revenue" and relationship is set Revenue one-to-many Invoice. And I created a List report with many records for entity Invoice. And the reportFilter is created based upon the List report.

    What is wrong with my setting?

    Thanks.
    Last edited by chrisjiang; 07-02-2020, 01:46 PM.
  • Maximus
    Senior Member
    • Nov 2018
    • 2731

    #2
    Hi,
    It looks good.
    1. Check whether the link is really called 'invoices'.
    2. Check whether the report filter is enabled.
    3. What is the target entity of the report?
    4. What is the target entity of the report filter?

    Comment

    Working...