View Single Post
Old 06-04-2020, 01:43 AM   #9
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by dunhill View Post
Davidfor!
We are close the two codes work half, let's say
I don't know why because the "V. Decimal" column has no format or code. I leave catches.
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.
Quote:
If the column has a value it is ok to put yes.
And it is expected that if it is empty it will put No but yes.
I don't want to be annoying, if you can't. I forget about those settings. Thank you very much for your time and for the prompt responses.
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".
davidfor is offline   Reply With Quote