Aggregation of rows

[Kat92]

Hi,

I have created the following calculation in set analysis in order to substract remaining time if it is more than 1 . It seems to be working great in a table with my field but it does not sum the total.

How can I roll up the following in order to calculate the total sum of all these cases?

if(
[Total per Day] > 1,
if(
sum(OutofField) >= ([Total per Day] - 1),
sum(OutofField) - ([Total per Day] - 1),
0
),
sum(OutofField)

[MayilVahanan]

Hi

Try like below

sum(Aggr(if(
[Total per Day] > 1,
if(
sum(OutofField) >= ([Total per Day] - 1),
sum(OutofField) - ([Total per Day] - 1),
0
),
sum(OutofField)), urdimensons))