asked on July 20, 2025
I need to count the fild Data Devolução in my report that is null on my csv, i tried a lot of formulas, but none has worked. Can you help me
⋅ July 20, 2025
I have asked IA to help but all the formulas didnt worked as planned
⋅ July 22, 2025
Hello,
Thank you for reaching out to us.
We recommend using the isNaN or !isNan function in the calculated value to count the null values. For example:
formula: "if(isNaN(max('Date')), 1, 0"
You can check our documentation for more details: https://www.flexmonster.com/doc/calculated-values/#formula-operators. You are welcome to refer to the following JSFiddle: https://jsfiddle.net/flexmonster/3eao64gu/.
Please let us know if it works for you. Looking forward to hearing from you.
Kind regards,
Nadia
