We need the null vales to behave as an absorbing element in flexmonster, since null represents an unknown value in statistical terms.
The operations null + a , null * a and null / a must all result in null, but in flexmonster the null is handled as a zero by default. Is there anyway to make the null become absorbent?
Thank you for your support.
Thank you for reaching out to us.
Kindly note that Flexmonster does not provide the feature of representing null as an absorbing element out of the box. However, you can customize the logic of aggregating the data by implementing the custom data source API. You can add any additional data processing in your server-side implementation using the custom data source API. For example, customize the logic of calculating totals and make the null become absorbent. The following guide will walk you through implementing your own server: Implementing the custom data source API server.
Please let us know if it works for you. Looking forward to your response.