Saving blank in input ready cell through IR Query

Hi,

My Question is regarding saving blank values in an input ready cell.

I have built an input ready Query, which works fine, so upon saving value for example KF1 = 30 for Customer = 12345 it does save this value.

Now, when i try to delete this value by selecting and backspace and try to save, the value (30) reappears.

At the same time, when i plan a value zero (0) instead this works fine.

I understand that logically a blank cannot be saved for a Key figure that is why when we delete or wipe off the key figure value it does not save, is there any backend settings where we can specify that when the value is deleted (i.e. if the KF is left blank) this value should be treated as zero?

Thanks,

Shweta Salpe