Skip to main content
G
gsfeliu
February 8, 2022
Solved

DynCalc displaying zeros

  • February 8, 2022
  • 2 replies
  • 0 views

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?

gsfeliu_0-1644313136601.png

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

Best answer by EricOsmanski

Try taking off ".CellAmount". That should have it return NULL.

2 replies

E
EricOsmanskiAnswer
February 8, 2022

Try taking off ".CellAmount". That should have it return NULL.

G
gsfeliuAuthor
February 9, 2022

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

Terms & ConditionsAccessibility statement