How can Add a row in my view to show the totals

(0) Share

Report

Posted on by James_Oliver

I have a view in which there is a column name cost. Now I have show the total cost.
how can I show that in a view

anyone?

thanks in advance.

All responses (16)

Answers (1)

huijij on at

Like (0)

Report

RE: How can Add a row in my view to show the totals

Hi James,

Do you mean to show a numeric column’s total ,can you share more details?
Martin Dráb on at

Like (1)

Report
RE: How can Add a row in my view to show the totals

You can use a query to get data from the view. If you want to get a total cost of several records, use sum aggregation function.

For example:

MyView myView; select sum(Cost) from myView;

But you didn't explain where you want to show the value, thefore I can't say what exactly you need to do.
James_Oliver on at

Like (0)

Report

RE: How can Add a row in my view to show the totals

Thanks for your reply Mr.Martin

----------------------------------------------------

Explanation:

I want to show the Sum Value in the view.

----------------------------------------------------

is it possible that somehow I can add a row or anything in the view to show the Sum value.?
Martin Dráb on at

Like (1)

Report

RE: How can Add a row in my view to show the totals

I still don't know anything about your actual requirement, but it seems that you want a view with both transactions and a total, which doesn't make a good sense. The total doesn't belong there - let the view return transactions and query them in any way you like, which includes calculation a total of cost value or some or all transactions.
James_Oliver on at

Like (0)

Report

RE: How can Add a row in my view to show the totals

Hi Judy,

Thanks For your reply.

Yes sure,

Details:

-------------------------------------------------------------------------------------------------------------

I have a view in which there's a column name $Cost , Each record has some $Cost

so what actually I am trying to do is, I have to calculate the cost of all records and show in the view.

-------------------------------------------------------------------------------------------------------------

If not in the view plz share your idea where can I easily show the calculated Cost of all records

Thanks
huijij on at

Like (1)

Report

RE: How can Add a row in my view to show the totals

Hi James,

For numeric columns in UI, the grid footer will also display the total value of a column if applicable. To show a column’s total, right click on the column header and select Total this column.
James_Oliver on at

Like (0)

Report

RE: How can Add a row in my view to show the totals

Hi Judy,

Can find this when Right clicking on the columns header.
see..
Verified answer

huijij on at

Like (1)

Report

RE: How can Add a row in my view to show the totals

Hi James,
James_Oliver on at

Like (0)

Report

RE: How can Add a row in my view to show the totals

Hi Judy.

Thank you for your reply.

I guess I am using a different grid in which there's no any option for Total this column.

Can you plz tell me the name of this Grid that you are using.

Currently I am using Read-only Grid(default)

Thanks.
Martin Dráb on at

Like (1)

Report

RE: How can Add a row in my view to show the totals

Aha, so you're talking about a form. A view has a special meaning in both F&O development and SQL; I thought you meant that.

Make sure you've enabled "New grid control" in feature management.