Virtual Column calculates correct calculation but returning 0 value

[Jasper_Daanoy]

Hi everyone,

I have a problem with a virtual column that returns the correct value when I test the calculation, however it does not display the values, instead only returning 0.

Here’s my virtual column:

When testing it, it actually returns the correct results:

But when i try to run it in the App UI, it is only returning 0 value:

Tried viewing it in the synced values but still, it returns 0:

Any help or tips would be appreciated.

Thanks in advance!