NA to 0 in the lobby element

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