View Single Post
Old 06-04-2020, 06:34 AM   #11
dunhill
Guru
dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.
 
dunhill's Avatar
 
Posts: 897
Karma: 810834
Join Date: Sep 2017
Location: Buenos Aires, Argentina
Device: moon+ reader, kindle paperwhite
Quote:
Originally Posted by davidfor View Post
The use of comma or dot is a locale thing. Australia and I think most English speaking countries use a dot with the comma as the thousands separator. And from memory, most European use a comma for the decimals and spaces for the thousands.


My quick and dirty cheat is to return a value that triggers the appropriate response if the column is empty.

Code:
program:
cmp(list_item(ifempty(field('#gr1'),'0,1'),1,','),0,'','Yes','');
That should work assuming I changed from my test version to yours properly.

@chaley: I tried the raw_list, but, it gave me the error "is not a list".

Yes now!!!! Genius thank you very much !!!
Thanks also to @chaley for the suggestions
dunhill is offline   Reply With Quote