Create division using Table calculation

  • 9 April 2018
  • 1 reply

I am trying to calculate below formula.


I have field APR in table as well as Principal. How do I do that using table calculation?

1 reply

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!