asked on March 7, 2024
Hi All,
Currently Calculated Field Pop-up only supports Add, Subtract, Divide, Multiply, ABS, MIN, MAX and so on.
Is there any way to achieve above functionalities ?
We are already using custom data source API for adding custom aggregated functions.
Happy to hear from your team!!!
Thanks
⋅ March 8, 2024
Hello, Aashish!
Thank you for reaching out to us.
Kindly note that our Calculated Values feature is mostly about adding new numbers on the grid with more complicated formulas than simple sum/average. It is a client-side feature that takes fields already present in the data source as a base and returns a new measure field with formulas applied as a result.
Custom data source API approach certainly provides more flexibility in processing and aggregating the data, but writing formulas to create new non-numeric fields in runtime is still beyond its capabilities. As a partial workaround, we suggest defining additional fields on the backend that will be calculated/created according to your custom logic, and then display them in Flexmonster as regular fields.
Hope our answer addresses your question.
Kind regards,
Solomiia
