RE: Formatter that only shows decimals
Peter, You may have to string it, and replace the decimal with nothing… Hth. David Ringsmuth From: Peter Jakobsson via 4D_Tech Sent: Saturday, April 6, 2019 6:01 PM To: 4D iNug Technical Cc: Peter Jakobsson Subject: Formatter that only shows decimals Hi Does anyone know how to do a formatter that only shows (currency) decimals but that hides the decimal point ? I have used ".00;-.00;00” which works ok except that the decimal point itself displays. I’d like to only display the numerics without the point if poss. Thanks in advance for any tips. Peter ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Formatter that only shows decimals
> On 8 Apr 2019, at 00:19, Mark Katz via 4D_Tech <4d_tech@lists.4d.com> wrote: > > Maybe (likely) I’m missing something but couldn’t you display the actual > value x 100 instead of the actual value? Hi Mark Yes, I could do that. I was just wondering if the formatter could do it because it would ideally be desire-able to not reprocess the original data in this case. (i.e. I just want to display the number of pence/cents that’s there not calculate them). Peter ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Formatter that only shows decimals
Maybe (likely) I’m missing something but couldn’t you display the actual value x 100 instead of the actual value? > Date: Sun, 7 Apr 2019 01:01:07 +0200 > From: Peter Jakobsson > To: 4D iNug Technical <4d_tech@lists.4d.com> > Subject: Formatter that only shows decimals > Message-ID: <0108b15b-4527-4985-aa42-bceaabe49...@netkelvin.com> > Content-Type: text/plain; charset=utf-8 > > Hi > > Does anyone know how to do a formatter that only shows (currency) decimals > but that hides the decimal point ? > > I have used ".00;-.00;00” which works ok except that the decimal point itself > displays. I’d like to only display the numerics without the point if poss. > > Thanks in advance for any tips. > > Peter > ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **