AnsweredAssumed Answered

Calculation to get data from a specific related field

Question asked by madmike6537 on Apr 21, 2014
Latest reply on Apr 27, 2014 by madmike6537

Hello there,


I am trying to create a calculation that will get data from a specific table::field, and use that data for my caculation result.


Basically, I am billing for customer equipment, but I want to bill not only for the cost of the equipment, but times how many days its been there. So I have a billing line item record - and I have a related peice of customer equipment:


Billing_Line_Item::Equipment_KF >----- Customer_Equipment::KP


Inside of the Customer_Equipment table is a field called number of days (the number of days the equipment was at the customer's location). I want to get that data, and multiply it times my billing item cost.


First I thought I could just do this:


Total =

Billing_Line_Item::Cost * Customer_Equipment::Num_Of_Days


But it turns out, that when you do this (from what I read), it just grabs the first record in that table, not a specifically related record. But I have both the record number of the equipment, as well as the primary key, so now I am trying to do this:


Total =

Billing_Line_Item::Cost * (GetNthRecord(Customer_Equipment::Days_At_Location; record#here))



But its not working.


What am I missing? Thanks and I hope that wasnt too confusing...