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)

Sort by

Verified answer

Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!

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
Keshav_ 55 on at

Like (0)

Report
Copy link

Link copied!

Thanks Rustem Galiamov .it is working.

Was this reply helpful? Yes No
Verified answer

Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Keshav_ 55 on at

Like (0)

Report
Copy link

Link copied!

Ok i did.

Was this reply helpful? Yes No
Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!

Thanks!

Was this reply helpful? Yes No