Numeric field always zero? - Objectif Lune Tech Support Self Help

IMPORTANT ANNOUNCEMENT

These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

You are not logged in. [Log In] Objectif Lune » Forums » PlanetPress Suite 5 » PlanetPress 5.x - Read-Only » Numeric field always zero?

Topic Options

#21196 - 10/08/09 11:05 AM Numeric field always zero?
JenV OL Newbie Registered: 10/07/09 Posts: 17 Loc: Rhode Island, USA	Trying to set 2 simple conditions (<0 or >0) selecting a field (database emulation) which either contains the value -1.0000000 or a "dollar" amount >0 (ie 42.4200000). However, PP5 always sees the field as =0
Top

#21197 - 10/08/09 11:17 AM Re: Numeric field always zero?
Anonymous Unregistered	JenV, Try doing this as your condition: =strtocur(Field('FieldName')) >0 The "Currency" is a number with 2 decimal points, and it should be correctly compared to the 0 even if it's an integer. Hope this helps, Eric
Top

#21198 - 10/08/09 11:33 AM Re: Numeric field always zero?
JenV OL Newbie Registered: 10/07/09 Posts: 17 Loc: Rhode Island, USA	That did the trick ~ thank you, Eric! (It's been a long week) ~ Jen V.
Top

Previous Topic

Index

Next Topic

Hop to:

Moderator: cosimo, OL Newsgroup Support