asked on March 13, 2019
Hi guys,
my name is Alfonso Davide Pilato. I work as software developer in Italy.
I am very interested in buying your component, but I would like to know if there is the possibility of inserting a custom aggregation formula.
I await an answer.
Regards
A.
⋅ March 14, 2019
Hello Alfonso Davide Pilato,
Thank you for your question.
Could you please give us more details about which formulas you would like to implement in Flexmonster?
We are looking forward to hearing from you.
Best Regards,
Vera
⋅ March 14, 2019
Hello Vera,
Thank you for your answer,
I try to describe my problem better:
In the first attached file: I have a table with a column and aggregated measurements where the turnover is a calculated value (price * quantity).
As you can see there is a problem on the sum of the price, I would like it to be calculated with a formula ( sum(turnover) / sum(quantity) ) weighted average .
The sum of the aggregate price measure does not make much sense.
I hope I was clear
Best Regards,
Alfonso
⋅ March 15, 2019
Hello Alfonso,
Thank you for specifying your needs.
You can achieve the desired output by using calculated values.
Here is a JSFiddle demonstrating the solution for the problem you described.
Please let us know if everything works fine for you and if you have further questions.
Best Regards,
Vera
