Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 6068 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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.

Posted

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.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.