Create a new Function

[#1]

Hi,

I would like to create a new function that I can use to display in a statistics box. Basically the function would do this equation:

(Total No. Hours) x (Hourly Rate) = Total Service Pay

I was trying this lines on the script but can't seem to make it work.

Sum([# of Hours]) as TotalHours

Sum([# of Hours])*[Hourly Rate] as TotalServicePay

I guess making a function is better. So I can display it on a statistics box.

[Anonymous]

Hi Charles,

This is not right:

1. You are not calling a table.
2. Your files are not on the same table.
3. You ar not doing a group by to accumulate values.

But with my other response you will have the correct result.

Regards!

[Anonymous]

You're wellcome!