Skip to main content

Fields from empty data in this element appear as NA. How to change that these NA s are 0.

Hi @Sena Kayıkçı 

Is this a lobby element you have created yourselves or in a std IFS lobby?

Regardless, depending on the data source, you could potentially update the SQL generating that column to something like

nvl(field_name,0)

or

case when field_name = ‘NA’ then 0 else field_name end

 

hope this helps


Hi @WyrDavidB ,

I already tried this but it didn’t work.

Is there any other place where ı can use nvl?

 


Hi @Sena Kayıkçı 

Can you share the code for the data source please - I suspect that you will need to make the change in the data source, instead of the element.

Dave


Hi @WyrDavidB ,

Of course.

 


@Sena Kayıkçı - I’ve done a bit more digging - assuming that this is a matrix type element, I don’t think there is anything else you can do here.

The NA’s are being generated by the element, not the data source.

Others may know different, but I can’t see or think of a method to replace these NA’s with a number. Good luck!


Okay @WyrDavidB , thank you.

Good luck!

 


Hello,

We get the same issue simce we move to IFS Cloud.
I dit not find any trick yet.

Does anyone found a solution ? 

kind regards

Anthony


Reply