calculating the right values

[Adam Runtime]

Hi

I have a calculation for a Cost field I need to do... I need to make sure only the relevant fields are used from other tables, so i need something like this:

sum ( Equipment::RatePerDay ) where EquipmentRental::EquipmentID = Equipment::EquipmentID ....

the problem is in the WHERE ... whats the keyword in FM for this???

Thanks

[RalphL]

Costs change with time, therefore you don't want to use relationships to get cost. Use a lookup, the value does not chaneg unless a re-lookup is performed. The lookup is based on a relationship. The cost is no longer a calculation but a number field. The extended cost = cost * time.

[QuinTech]

Hi Adam, FM does not actually use WHERE statements like SQL does. When you initially set up the relationship, you are effectively creating the WHERE portion of a SQL statement. Thus, if you have a relationship between Equpiment and EquipmentRental based on EquipmentID, then you could just use

Sum ( Equipment::RatePerDay )

to get the result (i think) you're looking for.

Does this help?

Jerry