rvfowler2
asked on
FM - Truncating 3 digits to Only Show Thousands
I am trying to chart and need to save space. I want to create a formula that reduces the amount field down to thousands, but without the trailing 3 zeros. I tried Truncate (Amount; -5), but that returned 0 for say a number of 15,000. How do you delete or not show the last three numbers on the right, so I could just say 15K for example? Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The first answer did it, though the second did add a bit. I did change the 0 to a 1 to add more granularity. By the way, I'm new to this charting, and it is terrible as compared to, say, MS Excel. Very little ability to customize, e.g., field, line, color, and row formatting on the chart.
FileMaker charting is a recent addition, and is not very robust. It's mostly there to provide quick and easy presentation of data without having to go outside the FileMaker interface. Personally I think charting is not that valuable in a database, but it was a common complaint that FileMaker didn't provide it, so they added it.
If you want Excel-like charting, your best bet is to use Excel. That's what I do. You can use the FileMaker ODBC driver as a data source to create more dynamic charts without having to do exporting/importing all the time.
If you want Excel-like charting, your best bet is to use Excel. That's what I do. You can use the FileMaker ODBC driver as a data source to create more dynamic charts without having to do exporting/importing all the time.
Truncate(Amount/1000;0)
or, even better:
Round(Amount/1000;0)