Fields from empty data in this element appear as NA. How to change that these NA s are 0.
Hi
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
I already tried this but it didn’t work.
Is there any other place where ı can use nvl?
Hi
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
Of course.
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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.