Sum value with conditions in other columns give by the treated row for over rows
I want to sum value where conditions are gives in the row (yellow in picture) to select over rows which have to be sum. The two columns "RankMove PM n-1" and "RankMove PM" are conditions for over rows. The sum have to sum only rows where EQTNAME is the same.
If NAME_PM is null, sum = 0
sum "trackout" if "RankMove" > "RankMove PM" and "Rankmove" < "RankMove PM n-1"
Someone has an idea ? Is it possible in spotfire to make this ?
It's like a SumIf in excel.
Thanks a lot for your help ! :-)
The format for a sumIF statement looks like :
Sum(IF [Column] = x , [Column], Null))
So for your exact use should look something like :
Case when NAME_PM is null then 0 else Sum(IF([RankMove] > [RankeMove PM] and [RankMove] < [RankMove PM n-1],[trackout],0 )) end
Of course you can do SumIfs in Spotfire.
Can you please share your data with expected outcome, for example as Excel file. Then we can wotk on this.