02-08-2022
04:45 AM
- last edited on
05-02-2023
10:09 AM
by
JackLacava
Hi all,
I have a dynamic calc that displays zeros instead of null when the source cell is null.
In the image below, MTD_CF is dynamic and it shall display None data under certain conditions. When None is null, MTD_CF is showing 0. Is there a way to avoid this so the dynamic calc shows nulls as well?
I've tried with RemoveZeros, like this:
Return api.Data.GetDataCell("RemoveZeros(V#" & view & ":U1#None)").CellAmount
The code returns the result, but does not remove the zeros.
Any ideas?
Thanks in advance.
GSF
Solved! Go to Solution.
02-08-2022 11:03 AM
Try taking off ".CellAmount". That should have it return NULL.
02-08-2022 11:03 AM
Try taking off ".CellAmount". That should have it return NULL.
02-09-2022 03:36 AM
Thanks Eric.
That worked. In an earlier version of my script I had to add ".CellAmount" for it to display any data at all. I did not think about removing it from the final version.
Regards,
GSF