Lantica User Forum - Clear a money value if 0?

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Clear a money value if 0?

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: 1

Send Topic

Print

Normal Topic

Clear a money value if 0? (Read 567 times)

Infinity Senior Member Members Offline Diagonally parked in a parallel dimension Posts: 1290 Location: Massachusetts Joined: May 27^th, 2005	Clear a money value if 0? Nov 8^th, 2006 at 6:39pm	Print Post
	The following is not working with my money elements (on-element change): Code IF THISELEMENT = 0 THEN CLEAR(THISELEMENT) The elements stays as $0.00. I've also tried each of the following: Code IF THISELEMENT = "0" THEN CLEAR(THISELEMENT) IF THISELEMENT = "0.00" THEN CLEAR(THISELEMENT) IF THISELEMENT = "$0.00" THEN CLEAR(THISELEMENT) but still no luck. Any advice?

	** Captain Infinity
	WWW IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Clear a money value if 0? Reply #1 - Nov 8^th, 2006 at 6:59pm	Print Post
	Try Code IF @ToMoney(THISELEMENT) = 0 THEN CLEAR(THISELEMENT) Or Code IF THISELEMENT = "0.000000" THEN CLEAR(THISELEMENT) -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

Infinity Senior Member Members Offline Diagonally parked in a parallel dimension Posts: 1290 Location: Massachusetts Joined: May 27^th, 2005	Re: Clear a money value if 0? Reply #2 - Nov 10^th, 2006 at 6:22pm	Print Post
	Thanks Ray. I used the first one; works well.

	** Captain Infinity
	WWW IP Logged

Page Index Toggle

Pages: 1

Send Topic

Print

‹ Previous Topic | Next Topic ›

« Board Index ‹ Board Top

Top

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid XHTML

Valid CSS

Powered by Perl

Source Forge