asked on June 11, 2018
Hi
I would like to display 'N/A' if the price is empty (not value 0)
see value for red :
https://jsfiddle.net/6a0r3h2n/
Thanks
Franck
⋅ June 12, 2018
Hello Jaffrezic,
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.
Regards,
Dmytro.
⋅ June 12, 2018
Hi Dmytro
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.
Regards
Franck
⋅ June 12, 2018
Hello Jaffrezic,
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.
Regards,
Dmytro
⋅ June 13, 2018
Hi Dmytro
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 :
https://jsfiddle.net/80e5r39p/
Regards
Franck
⋅ June 14, 2018
Hello Jaffrezic,
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.
Regards,
Ian
⋅ June 18, 2018
Hi Ian
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
Regards
Franck
⋅ June 19, 2018
Hello Franck,
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.
Regards,
Dmytro
⋅ September 27, 2018
Hello Franck,
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.
Regards,
Ian
