How to calculate total value of field called "Value" In AOT Report(Sales_invoice)

(0) Share

Report

Posted on by Keshav_

Hi Experts,

I want to calculate the total value of a field. I have field called "Value" and i want the sum of all the numbers in the "values" field in Total field. if Anybody knows please post your solution here. Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (2)

Rustem Galiamov 8,072 on at

Like (0)

Report

RE: How to calculate total value of field called "Value" In AOT Report(Sales_invoice)

Thanks!

Was this reply helpful? Yes No
Keshav_ 55 on at

Like (0)

Report

RE: How to calculate total value of field called "Value" In AOT Report(Sales_invoice)

Ok i did.

Was this reply helpful? Yes No
Verified answer

Rustem Galiamov 8,072 on at

Like (0)

Report

RE: How to calculate total value of field called "Value" In AOT Report(Sales_invoice)

You are welcome! Can you please change "Unanswered" status of question?

Was this reply helpful? Yes No
Keshav_ 55 on at

Like (0)

Report

RE: How to calculate total value of field called "Value" In AOT Report(Sales_invoice)

Thanks Rustem Galiamov .it is working.

Was this reply helpful? Yes No
Verified answer

Rustem Galiamov 8,072 on at

Like (0)

Report

RE: How to calculate total value of field called "Value" In AOT Report(Sales_invoice)

Hi!

You should use "select sum(Value) from Table where ..." statement and then return the value of table.value.

Was this reply helpful? Yes No