Convert IC50 values to pIC50 values

Converting values between units is currently addressed through creating new calculated columns.

In your dataset page, in the Columns tab, you can find the New Formula Column button on the top right:

Click on it. That'll open the settings panel to create a customized column based on a formula.

For the example below, we have an IC50 column expressed in nanomolar which we want to transform in pIC50. To do so, proceed as follows:

• Enter a name for the new column. It must be unique - there is currently no way to override an existing column.

• Next the formula. Start typing "-log(". Then, you can start typing the column name. Autocomplete will suggest you the list of matching columns, you can then click on the column to convert and finish by closing the parenthesis. You should end with something like this:

• Click on Create. Your calculated column has been added to your dataset, and you can use it as any other columns.

As a reminder, until we introduce pre-defined conversion functions, here are a bunch of formulas that might be useful for unit conversion when using IC50s.