Forum Discussion

michaelsparrow's avatar
michaelsparrow
Icon for Helper I rankHelper I
9 years ago
Solved

New column - value depends on another column

  Hi, I can't figure this one out. I want to add a column to this table which equals: 120/Number of times a 'Staff Num' occurs in the 'Staff Number' Column. So if 49974 occured 60 times in S...
Need Help
  • michaelsparrow's avatar
    michaelsparrow
    9 years ago

    the number is still about 100 times higher than the number i am looking for.

     

    That's ok, i'll just use constant lines.

     

    cheers

michaelsparrow's avatar
michaelsparrow
Icon for Helper I rankHelper I
9 years ago

Hi,

 

THanks a lot.

Isn't working exactly right, but getting close i think. I've changed it a little bit as you can see below.

However, the value in the 'New Column' is 50.44 whereas it should be a very small number. Looking to divide 280 by the number of times that MCFA shows up, then also the number of times CAT7, then also the number of times FAT7, all in the same column.

Cheers

 

Mi2n's avatar
Mi2n
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Just change the last part of the formula from Divide(X,Y) to Divide(Y,X)