grumbachr Posted June 12, 2008 Posted June 12, 2008 I feel kind of dumb even asking but I need too. I have a startfield and and endfield. I need to know what percent the endfield is of the startfield. startfield = 50 endfield = 25 I know its 50% but i'm not sure how to write this in FileMaker TIA
grumbachr Posted June 12, 2008 Author Posted June 12, 2008 Thanks for helping me. I guess my question should have been a little different. I didn't ask for what I really ended up needing. I ended up going with this. Let ( [$$mid = Start - End] ; $$mid / Start * 100 & "%" ) Thank again you did help me out.
comment Posted June 12, 2008 Posted June 12, 2008 Well, that actually answers what percentage of Start is the difference. However, I would suggest: 1. Do not use $$variables in a Let() function, unless you need them elsewhere; 2. Instead of multiplying by 100 and appending the % sign, make the result a Number and format the field to display as percentage.
Recommended Posts
This topic is 6068 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now