Microvellum Community

Report - Display Dual Dimensions in mm and fractional inches

Hello,
What is the report expression to convert a decimal number to the nearest 1/16" on a report when the MV options are Imperial, Decimals, and "Yes" convert to metric?

These expressions show both the dimensions as decimals and I'd like to see the imperial units as fractions to the nearest 1/16".
{MVValueFormat(Products.Width)}mm
{IIF(MVGetConvertToMetric = "yes", IIF(MVGetUnitType = "imperial", (Products.Width / 25.4), ""), "")}"

{MVValueFormat(Products.Height)}mm
{IIF(MVGetConvertToMetric = "yes", IIF(MVGetUnitType = "imperial", (Products.Height / 25.4), ""), "")}"

{MVValueFormat(Products.Depth)}mm
{IIF(MVGetConvertToMetric = "yes", IIF(MVGetUnitType = "imperial", (Products.Depth / 25.4), ""), "")}"

This link explains the report value format, but doesn't explain how to change or use dual formats.

    Toolbox BSB Survey



    Have you been using Toolbox BSB? We'd love to hear what you think!

    Take the Survey

      MVU eLearning



      Grow Your Knowledge
      Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.


        Follow us on:

                 

          ERP for Millwork Shops


          Discover how Microvellum and INNERGY streamline operations for cabinet shops and millwork manufacturers.