How Does OLAP Calculate Liters(Canada) or Gallons(US)?

Last modified at February 12th, 2021

With the OLAP reporting tool there is a column that can be added to reports that gives the total gallons or liters sold. This calculation is based on specific units of measure that have been programmed into it. If a unit of measure is not listed here it will not be included in the calculation. Please contact support and we can report to development to have it possibly added in a new release.

These are the units of measure that are currently converted:

For Liters we convert

½,HALF,4,FOUR,20,TWENTY,2,TWO,3.75,10,15,60,6,5 

 

For Gallons we convert

½,HALF,250,35,25,15,10,3.5,2.5,6,SIX,5,FIVE,4,FOUR,3,THREE,2,TWO

 

For Gallon Drums we convert

50, 55

 

For Tote we convert

250

 

For Quarts/QRT we convert

½,HALF,2,TWO

 

For Pint/PNT we convert

½,HALF,2,TWO

Was this article helpful?