I would like to display ‘N/A’ if the price is empty (not value 0)
see value for red :
Thank you for your question. Please find the following jsfiddle example: https://jsfiddle.net/flexmonster/6a0r3h2n/14/.
Let us know if it works for you.
Thanks for your answer, but it doesn’t work form me.
I would like :
for Blue Total Sum Price = 0 and test = 0
for Red Total sum Price = N/A and test = N/A
See : https://jsfiddle.net/ygc02we5/
See attach files is expected result.
Thank you for your feedback. Please have a look at the following workaround: https://jsfiddle.net/flexmonster/ygc02we5/7/.
Let us know if the suggested approach works fine for you.
Thank for your answer, but it doesn’t work because if the price is equal to -1 it display N/A
See Total sum for yellow it display N/A it should display value -1 :
Thank you for the answer.
Here is an improved version: http://jsfiddle.net/flexmonster/uacsn8q9/
We understand that it is kind of workaround and will add this case to our backlog (to think about a better solution).
Also, you can change magic `-1` value with something different to avoid collisions.
Hope it helps.
Thank you for your answer, but it’s not a good solution, because I can not know which unique name.
The best solution would be to be able to differentiate the value 0 from the value null
Thank you for your feedback. Our component does differentiate when the raw data has either 0 or null values. However, the behavior is a little bit different when it comes to the custom calculated measures. If some field of the formula has the null value the component will use 0 instead of it for the calculations. Pivot table in Excel works the same way when it comes to the calculated values. Therefore, it is the default behavior of our component. At the same time, if you need the calculated value to be null when some field of the formula is null, we will be ready to implement this approach for you as our customer.
Please let us know if there is anything else we can help you with.
We are glad to inform you that we have added a new property
calculateNaN to the calculated values and now you can easily check that the value is empty: http://jsfiddle.net/flexmonster/uacsn8q9/20/ (see line 30).
Hope it helps.