Sum of If with calculated value

[ragosu66]

I need your help to find a solution to the next issue. I am trying to write a nested if statement with calculated value condition:

Sum( If((Closed_Timestamp - Max({<Display_Name = {'Assignee'}>} Modified_Time)) > ((1/24/60) * TTF), 1, 0)

I tried different solutions to sum them, but anything seems to work when I saw Total row.

[Gysbert_Wassenaar]

You can't nest aggregation functions like Max and Sum without using the Aggr function.

But perhaps you want to use the value of Max({<Display_Name = {'Assignee'}>} Modified_Time) that's calculated at the document level instead of in the context of a charts dimensions. In that case try

Sum( If((Closed_Timestamp - $(=Max({<Display_Name = {'Assignee'}>} Modified_Time)) ) > ((1/24/60) * TTF), 1, 0)

Other wise you'll have to use the aggr function and specify over which dimensions the max should be calculated.

Sum( If((Closed_Timestamp - aggr(Max({<Display_Name = {'Assignee'}>} Modified_Time),DimA,DimB,...DimX) ) > ((1/24/60) * TTF), 1, 0)

[ragosu66]

Thanks Gysbert

Your sample was the clue to find the correct code.