Total cost

[Shpilmaa]

Hi guys,

i have a table with cost and qty that changed every time, for example:

Cost 179 and qty 2 or 3 (it can be any number)

i want to make a report with bar chart for total cost, how can i make it?

thanks for advance!

[Anil Lande]

Hi,

You can create a column name it as Total coset. you can save multiplication of Cost and Quantity in that field (using before BR) and it is easy to report on Total cost column.

[Shpilmaa]

Hi, Thanks

It sounds right, but can you please expand? where do i have a multiple function (cost*qty) i cant find it 

[Anil Lande · Accepted solution]

You can create before (insert and update) business rule on your table.

Use script to calculate "Total Cost".

var totalCost = parseFloat(current.u_cost.getCurrencyValue()) *  parseFloat(current.u_quantity);
current.u_total_cost = current.u_cost.getCurrencyCode() + ';' + totalCost ; 

Note: replace your column names in above script.