Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello everyone
First of all I apologize if this message is not correctly located within the forum locations.
I'm trying to treat a field that includes some values with a format that I can't recognize, as shown in the following picture.
this is the "Importe" field, which I need to take the value '0' and which I can deal with from the application view section. the problem is that I need to do this transformation at script level.
so far I have tried to do it through sentences of the type:
if(isnull(Importe), 0, Importe)
if(isnull, '0', Importe)
if(isnull, '', Importe)
if(isnull, ' ', Importe)
(...)
*I have also considered the possibility of it being a text type and I have tried to transform it, but it still cannot be identified.
none of them work, I appreciate any idea or suggestion, greetings
If Importe is a numeric field you can use the alt() function.
Try this:
ALT(Importe,0)
First of all, thank you for answering. I have tried the solution you propose, but without success. Apparently and as I commented in my first message the problem lies in the type of elements in question that do not seem to be null, as can be seen below:
I still can't find a solution to the problem.
It depends on the cause of NULL what you may do to get your wanted visualization. The best explanation for it is:
- Marcus