Skip to Main Content
Status Awaiting Review
Categories Gradebooks
Created by Guest
Created on Jun 13, 2024

Add the right Truncate function in formulas

The truncation formula is not really available in the formulas menu, several schools in South America uses this system where need a grade that a raw calculation is 7.54653 to be shown as 7.54 (with 2 decimal places with NO ROUNDING); we have been told to use the Floor formula to get the same results.

However, this have produced error in some calculations which make reduce reliability Gradebooks and increasing operational risks.

The current TRUNC formula will round to an integer, instead of work as Excel does asking which number of decimal places you need to be shown (see attached).

  • Attach files
  • Guest
    Reply
    |
    Jun 14, 2024

    This functionality is very relevant to most LATAM Countries, and it should be quite simple for ISAMS to deploy. Please do include it.