Min IF function : SAP Dashboard

Question

I have calculated Minimum value using MIN and IF functions in Excel for the below mentioned data using Array function. Below is the screen shot for your reference:

This works absolutely fine, but when I try to write this in SAP Dashboard (Xcelsius), this array function is not working properly.

Is there any other way to achieve the results. All I want is min value of each team. Any help would be greatly appreciated.

Thanks, Ganesh

Answer 1

I found answer for this question. I used "Sum if" function as the status is always 1 or 0 : =IF(SUMIF(C:C,Q4,G:G)>=6,1,0)

Thanks, Ganesh