AnsweredAssumed Answered

Calculate sales tax within a given field?

Question asked by MacAddict4 on Nov 18, 2015
Latest reply on Nov 20, 2015 by MacAddict4

A newbie (or maybe a "dumbie") to FM Pro. Can someone please explain exactly what I need to do to automatically calculate (and enter) Sales tax within a field titled "Sales tax" that I have already created within my data base. The calculation would be based on the original purchase price (which is another field that I have already created). Although irrelevant, the sales tax in my State is 6.25%.  In a spreadsheet, I would know exactly how to do this but in this database, I'm lost..... (how does one create a formula based on a relationship between "cells" but do this in a database? Please, please don't hit me with something like, "use or create a Script" because I would have NO IDEA how to do this.

Outcomes