grumbachr Posted June 12, 2008 Share 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 Link to comment Share on other sites More sharing options...
comment Posted June 12, 2008 Share Posted June 12, 2008 endfield / startfield Link to comment Share on other sites More sharing options...
grumbachr Posted June 12, 2008 Author Share 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. Link to comment Share on other sites More sharing options...
comment Posted June 12, 2008 Share 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5789 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