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

(0) Share

Report

Posted on by James_Oliver

186

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.

I have the same question (0)

All responses (16)

Answers (1)

huijij 19,811 on at

Like (0)

Report

Hi James,

Do you mean to show a numeric column’s total ,can you share more details?

Was this reply helpful? Yes No
Martin Dráb 237,912 Most Valuable Professional on at

Like (1)

Report
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.

Was this reply helpful? Yes No
James_Oliver 186 on at

Like (0)

Report

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.?

Was this reply helpful? Yes No
Martin Dráb 237,912 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
James_Oliver 186 on at

Like (0)

Report

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

Was this reply helpful? Yes No
huijij 19,811 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
James_Oliver 186 on at

Like (0)

Report

Hi Judy,

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

Was this reply helpful? Yes No
Verified answer

huijij 19,811 on at

Like (1)

Report

Hi James,

Was this reply helpful? Yes No
James_Oliver 186 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Martin Dráb 237,912 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No