Difference between Sum(Price) or Total(Price) ??

[nikhilgarg]

Hello,

I have 3 fields :

ID_No , Price , Department.

Now if i want sum of price i do:

Sum(Price) or Total(Price).

What is the difference between :  Sum(Price) or Total(Price)

Thanks

[anbu1984]

I didn't notice Sum in your question.

As Jagan said, Avg(Sum(Price)) is not valid.

[nikhilgarg]

Hey,

I got your point . But what i want to ask you i just tell you by an example.

Initially when nothing is selected i have month-Year on X-Axis showing price of products. I calculated Avg of them by :  Avg(TOTAL Price) which will take sum of all prices displayed and calculate avg.

Now if i select any of the month-year, it will show me prices of products on every date in that month. Now i want to calculate Avg of Prices. Now i use : Avg(TOTAL Price) . Now also it will take the sum of all prices on all dates in that month-year and do avg.

Am i right ??

[jagan]

Hi,

TOTAL will not ignore selections, if you select one month you will get total average of only that month.  If you want to ignore selections and dimensions then use this

Avg({1} TOTAL Price)

{1} - will ignore the selections

Regards,

Jagan.

[#5]

first of all no TOTAL function is there

instead we can use it as sum( total SAL)

see below image u can understand functionality.