Question

Create division using Table calculation

  • 9 April 2018
  • 1 reply
  • 2340 views

I am trying to calculate below formula.


(APR/365)*Principal


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!

Reply