Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use aggr function

In the table below, from every row I would like to have ND as MINUTI dived to the sum of all PRG row( i.e. 1440). How to do? Thank you

4 Replies
vinieme12
Champion III
Champion III

please post sample data in excel with expected output

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

USe TOTAL Keyword

sum(MINUTI) / SUM(TOTAL PRG)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
karthiksrqv
Partner - Creator II
Partner - Creator II

Hi,

Please try this:

sum(Minuti)/sum(TOTAL PRG)

sunny_talwar

How is sum of PRG = 1440? Can you share more details as to what kind of object are you using? How many dimensions do you have? What is your expression?