Create division using Table calculation

Hi Keyur,

You can simply type in the LookML version of APR and Principal into the Table Calculation box:

1. Give your calc a name if you want


2. Type (${APR}/365)*${Principal}


3. Click calculate.

This will give you the row by row calculation in a new column as long as ${APR} and ${Principal} are used in the Explore you are calculating in.

If you’d like to learn more about Table Calcs with Looker, feel free to take a look at this doc in our awesome Looker Documentation resource!