Forum Discussion
Solved
sum rows based on condition
Hi, can someone help me to make sum calculation of each heat up sequence, shown on exapmle. In excel I can make reference to previous cell of same column I calculate, here I managed only to refer to ...
Hi kadapavel,
Sorry I missed that.
Can you try this:
1. Create a column that saves the index of the last row before heating begins:
Heat Start = IF([Prev Temp]>0, MAXX( FILTER(Table2, [Index] < EARLIER([Index]) && [Prev Temp] = 0), [Index]))2. Use the following calculation:
Sum of Each Heat Up = IF([Prev Temp] > 0, SUMX( FILTER(Table2, [Index] <= EARLIER([Index]) && [Index] >= EARLIER([Heat Start])), [Prev Temp]))I believe it works:
Hi kadapavel,
Sorry I missed that.
Can you try this:
1. Create a column that saves the index of the last row before heating begins:
Heat Start =
IF([Prev Temp]>0,
MAXX(
FILTER(Table2,
[Index] < EARLIER([Index]) &&
[Prev Temp] = 0),
[Index]))
2. Use the following calculation:
Sum of Each Heat Up =
IF([Prev Temp] > 0,
SUMX(
FILTER(Table2,
[Index] <= EARLIER([Index]) &&
[Index] >= EARLIER([Heat Start])),
[Prev Temp]))I believe it works:
Thank you very much! Great solution!