How can I write a script for calculating a percent of another item. It will always be one half of one percent
If the item is a field then
Set Field [YourField; SecondField * 0.005]
same for Variable: Set Variable [$var; Value: $var2 * 0.005]
Any combination of field and variable will also work.
Be more precise please if you need more help
"always" never is...
Hard-coding anything is always discouraged. That being said, Thierry has a good answer.
Does it need to rounded or precise or something else on the value once calculated?
Come on back anytime if you have more questions!
Thank you Thierry! That worked perfectly
I am new to FileMaker so I appreciate the quick response.
I have one other project. I have two fields that are percentages but when I enter 5 it changes to 500% any ideas on how to change that?
You are welcome, come back anytime, I was happy to help. You might check answer correct so other will know that you got the answer to your problem.
Good to know. I have marked as correct.
Maybe you can help me with one other thing. I have two fields that are percents but when I enter 5 in auto changes to 500%. Any idea on how to change that?
I suspect strongly that the field is setup with % formatting. Go to layout mode, Select the field displaying 500, click on Inspector, choose fourth tab (looks like a multi level plates icon or hard drive) then in bottom change Data Formatting do not take Percent, experiment maybe decimal will be good or just General, it all depends on the possible values and how you want to display
Retrieving data ...