Forum Discussion
Help Brazil!
deisedc If "0027812-38.2005.8.26.0100" is your value, are you trying to extract only a portion of that for each row? I'm trying to understand how you are able to return anything using COUNT(NUMERO_PROCESSO) since it is a text field. You would need to use COUNTA(NUMERO_PROCESSO) if you wanted to count the number of times a value is present.
If you want to SUM NUMERO_PROCESSO then you need to reformat the value to be a valid number and change the data type...
I might not be understanding the specific issue/problem..
It's a Desktop version and the data type is a text. I have applied COUNT(NUMERO_PROCESSO) and it has returned a number. But this number doesn't accept the format. Example of data in the field NUMERO_PROCESSO = 0027812-38.2005.8.26.0100.
Could you help me?
Thank you!
deisedc If "0027812-38.2005.8.26.0100" is your value, are you trying to extract only a portion of that for each row? I'm trying to understand how you are able to return anything using COUNT(NUMERO_PROCESSO) since it is a text field. You would need to use COUNTA(NUMERO_PROCESSO) if you wanted to count the number of times a value is present.
If you want to SUM NUMERO_PROCESSO then you need to reformat the value to be a valid number and change the data type...
I might not be understanding the specific issue/problem..