Hi,

I have a portal in my solution with a number of calculation fields. 2 of these calc fields show $0.00 on the last row which is not a record.

The fields:

Desc Bid Price=

"Desc Cost + Desc MU Amt" &

Total Desc Bid Pre=

"Desc Bid Price * Quantity"

show $0.00 on the last row.

The fields:

Total Desc Cost =

"Desc Cost * Quantity" &

Total MU =

"(Desc M U Entry / 100) * Total Desc Cost"

show nothing.

All fields have same number format: format as decimal, fixed number of 2, $ notation, use thousands separator.

How can I get rid of the ghost $0.00 and what makes them appear on some calcs and not on others

Hi,

Your portal is set with "allow creation of related records" I would think.

check databasepros for a trick for 7, or do a search here with "ghost" as a key field as this was already covered in the past.

I did the search but came up with nothing

Hi,

There are a lot of posts hre xwith either "ghost" or "phantom".

One I can recall of is :

http://www.fmforums.com/threads/showflat.php?Cat=0&Board=UBB17&Number=57595

and here for 3 techniques....

http://www.filemakerpros.com/NEWROW.zip

Thank you,

the Databse pro link helped alot. But just out of curiousity, why do 2 of my fields stay blank and the other 2 have the $0.00 in them?

Hi,

"do not evaluate if empty" should be checked in the calc definition.

From Filemaker Pro 7 Article 108661, I typed into Scriptmaker this script.

It works but gives me essential ALL the duplicates. I need to see only records with 2 or more duplicates.

Where do I need to modify this script to make it work?

Thank you in adance for your help

Enter Find Mode [ ]

Set Field ["CountDups",""> " & GlobalDupsOK"]

Perform Find [Replace Found Set]

Sort [Restore, No dialog]

Pause/Resume Script [ ]

Go to Record/Request/Page [First]

Loop

Set Field ["GlobalOmit","GlobalDupsOK"]

Loop

Exit Loop If ["GlobalOmit=0"]

Omit Record

Set Field ["GlobalOmit","GlobalOmit-1"]

End Loop

Set Field ["GlobalCounter","CountDups - GlobalDupsOK"]

Loop

Exit Loop If ["GlobalCounter=0"]

Go to Record/Request/Page [Exit after last, Next]

Set Field ["GlobalCounter","GlobalCounter-1"]

End Loop

Exit Loop If ["Status(CurrentRecordNumber)=Status(CurrentFoundCount)"]

End Loop

Joe,

Welcome to the Forums.

You're posting in the wrong Forum, in an already opened thread with a totally different topic.

Please, delete and move your post where it should be and take the time to read the different titles of each Forum section.

do not evaluate was checked in all 4. just one of those things I guess.