calculated Fields using filters, partially not working

[Alexander Singer]

Hello together,
we're using ESPOCRM since more than a year now. We're just staring to dig deeper into this wonderful tool.

I'm using calculated fields on a entity and linked entity.

Is there any known bug on the funktion:
entity\sumRelated(LINK, FIELD, [FILTER])
when using a filter?


I'm using the same content with the function
entity\countRelated(LINK, [FILTER])
without any issues, just the function sumRelated is ignoring the filter.

Here is the exact syntax:

ifThenElse(entity\countRelated('einkaufspreise','r eportFilter5e1b3f132ec35cae1')==1,price=(entity\su mRelated('einkaufspreise','preisNetto','reportFilt er5e1b3f132ec35cae1')*flaeche),price=null));

The filter for countRelated and sumRelated is exactly the same, giving also the correct result on function countRelated, just when using sumRelated it is ignoring the filter and presents a result over all linked relations.

Thank you very much for your support.

Best regards

Alexander

[Maximus]

Hello,
I will check it, but it seems that formula has a syntax error. in the line "price=null));" the ")" symbol is needless.

[Maximus]

I have checked it and everything works as it should.