Return to FileMaker.com
Converting Numbers for Charts
I am charting monthly footage numbers on a chart and i'm wondering if there is any way to convert a number like 5,250,201 to something similar to 5.2 Million.
My charts have soo many long numbers on them and i'm needing to convert numbers in the millions to something smaller.
Thanks for the help!
Define calculation fields such as: Round ( MonthlyFootage / 1000000 ; 1 )
Where "MonthlyFootage" is the name of your field where you want to reformat the number for charting.
Retrieving data ...