AnsweredAssumed Answered

Nexel Calculation Problem

Question asked by asmeets on Dec 24, 2018
Latest reply on Dec 28, 2018 by asmeets

I am trying to use COUNTIF in nexel but it is not giving me what I am expecting. The formula is as follows for each block in the Priority column: -

=COUNTIF ( [@f;*;Range(1:7)], "<=" & [@f;1;*] )

=COUNTIF ( [@f;*;Range(1:7)], "<=" & [@f;2;*] )

=COUNTIF ( [@f;*;Range(1:7)], "<=" & [@f;3;*] )

=COUNTIF ( [@f;*;Range(1:7)], "<=" & [@f;4;*] )

=COUNTIF ( [@f;*;Range(1:7)], "<=" & [@f;5;*] )

=COUNTIF ( [@f;*;Range(1:7)], "<=" & [@f;6;*] )

=COUNTIF ( [@f;*;Range(1:7)], "<=" & [@f;7;*] )

This is what it is giving me in Board.

ProductMin QtySafety StockMax QtyDaily Sales QtyFG StockStock DaysPriority
170484228521142774728457111.3186
23050485411228780323411281173.9611
31367776594205161145011148907.9234
42668300118003028286002221.2246
54506182963379564777283885.9434
696832711324208410266406703.9623
7315283941020493333427788202.3580

 

This is what the same calculation gives me in Excel.

 

AB
11.318

6

3.9612
7.9235
21.2247
5.9434
3.9623
2.3581

 

=COUNTIF(A$2:A$8,"<="&$A2)

=COUNTIF(A$2:A$8,"<="&$A3)

=COUNTIF(A$2:A$8,"<="&$A4)

=COUNTIF(A$2:A$8,"<="&$A5)

=COUNTIF(A$2:A$8,"<="&$A6)

=COUNTIF(A$2:A$8,"<="&$A7)

=COUNTIF(A$2:A$8,"<="&$A8)

 

Thanks in advance

Outcomes