Thanks victor and rabii for your help
working great
Announcement
Collapse
No announcement yet.
entity\ any formulas not working
Collapse
X
-
Hi, Victor. Thank you very much, now I understand that I need to specify the name of the link, not the Entity
summ = entity\sumRelated('wynagrodzenies', 'kwota', 'reportFilter6396d8023ec542034');
-
deleted and re-created the relationship, perhaps I need to add additional relationship?1 Photo
Leave a comment:
-
Hi Vasyl Kasiianchuk,
1. Create a relationship between Wynagrodzenie and Lista Plac.
2. Instead of the word Wynagrodzenie, there should be the name of the relationship with the entity Lista Plac.
3. For example, if we want to calculate the amount of associated Opportunities for an Account, then we write
no:
Code:entity\sumRelated('Opportunity', 'amount');
Code:entity\sumRelated('opportunities', 'amount');
- Likes 1
Leave a comment:
-
just check the relationship link name and also try to recalculate formula.
Leave a comment:
-
yes i added ReportFilter now and got number /#ReportFilter/view/6396d8023ec542034
changed the formula
ilosc = entity\isRelated('Wynagrodzenie', 'kwota');
summ = entity\sumRelated('Wynagrodzenie', 'kwota', 'reportFilter6396d8023ec542034');
the formula doesn't work again
type of fields ilosc and summ is Varchar, read-only is true.
4 Photos
Leave a comment:
-
did you add the report as a filter to your entity?
You need to create a report filter based on this report (Administration -> Report Filters) and use the report filter ID in the formula instead of the report ID.
Leave a comment:
-
entity\ any formulas not working
Hi,
I try to calculate the sum in another table and count the number of records, but I don't get the results.
Why don't working any formulas entity\ (sumRelated and countRelated) for counting in other tables? may be due Relationships? Or am I doing something wrong?
3 Photos
Leave a comment: