### Title

Please Help with a logic field result thanks

### Post

I am new to this and I am trying to make a horseracing result database.

Using FMP 10 I have the starter course for VTC by John Osborne and I also bought The Missing Manuel but I'm still struggling

I have two Calculating Fields that hold the Possible Win amount which is simply Stake times odds

and the Possible Loss Field which is a minus Stake

I have a Field Finished with a dropdown showing if the horse came 1. 2. etc

I have a Won Lost Field where I would like to do an If function depending on the Finished Field if it came in 1st show the Win amounnt

But it returns the Name of the Field not the contents. same for if the horse came 2nd

any help would be much appreciated i have spent hours trying to work it out.

Thanks

davelee

You should be seeing the contents of the fields--not their names. Since you don't something isn't set up correctly.

If you were to copy and paste the expression directly from your file to this forum would it look

exactlylike what I've posted?I suspect you may have some quotation marks where they shouldn't be or this is not a calculation field like I've assumed.