Search the Community
Showing results for tags 'Calculation'.
-
I have a text field with this autoenter calculation: List (Table::PrimaryID ; 1 ). It works fine and returns the PrimaryID + carriage return + 1. No problem with that. Is there a different behaviour if this field is used in a relationship that I don't know. Because in my solution, sometime... -
I retrieve email records into a database for a to do list. The body of the email becomes the task. I want to be able to send emails to the databse with a date in the subject. I used "***dd/mm/yyyy***" as a pattern in another database so that when this pattern appeared in the body it was ex...
-
Hi.🌍 I need to add number values in the 'hours' field per client. The client is identified by unique 'name' or 'Id' I can do it either in a portal or in the layout itself. Any tips her. Thanks a bunch. -
I have a calculation that goes like that, I input a number on "Base Imponibile" (say 100), it adds 15% (it gets me 115), it then calculates 4% to the previous result (115) and it gets me 4,60, I then add 2 and the total is 121,60 which is perfect. And that's the part that works just fine. But I...
-
This should be easy, but my brain just won't cooperate! I'm moving a bunch of stuff and want to inventory what is in each moving container. I have a very simple parent-child relationship with the parent record having the container number and category of parts/equipment/supplies and the child r... -
Greets, all: I'm using this calculation--in a parent table in a field temporarily named 'Temp'--to grab course numbers from the course_number field in a related/child table: UniqueValues ( List ( ASSIGNMENT_COURSE::Course_Number__lxt ) ) (I'm using this calc because the child table co...
-
I know. Don't use them. But There is a simple task and a repeating field would be a quick solution. Field 1: a number Field 2: a calculated repeating field, each repetition adds the repetition number to the value of Field 1. Can it be done? Thanks
-
Gents, need your help on the following issue: I need to track my expanses. There are 4 tables: Products, PriceChanges, Transactions. The problem: I need to make a script which will make calculations in transactions tab, accounting for the latest price change. Example: 01 jan17 I...
-
I found a thread regarding this from 11 years ago, but couldn't find anything else so thought it may be best to check if the newer versions of FM have a solution to this problem. Is there any function or custom function that would allow me to check if the value in a field is numeric? I have a field...
-
Hello FM Mavens, I am likely missing something. I have a script step that calculates the dimensions of an image in a container field. There are many such fields so the script should work with any arbitrary one. I get the name of the field by using script parameter Get(ActiveFieldNa...
-
Hi, I am using this calculation in portal which calculates days in portal Date - (GetNthRecord ( Date ; Get ( RecordNumber ) - 1 ) ) how can i modify or do something else to avoid (?) in the first row. Sample file attached for any modification/help. Thanks for any help DateCalc.fmp12
-
Hello, Could someone help me with this question? I have a row in a portal in wich i would like to make a calculation: Bedrag= Cases*Prijs, but if Hoeveelheid is filled in then it should calculate Bedrag= Hoeveelheid*Prijs. The fields are all numeric. The calculation should be possible o...
-
Help Please, I am trying to figure out how to extract field contents via a calculation as follows: My lookup field is ABCDEFG-01-12345.jpg I want to automaticaly extract only 12345 to be placed into another field? I tried the Calculation Right ( Sorce field; 5 ) but that returns me 5.jpg...
-
Hi. I have a single field, call it LETTER, with a massive calculation, but I want that calculation to be vary depending on another variable, ie a person. (Tom, George, Pete, ... ). So I"m thinking I need a table of a calculation for each person. Tom and his calculation, George and his calcul...
-
Hello All, I am using the invoice starter solution, I add a Catalogue Field to the Invoice Data Table which is an (Text ; Indexed, Look up from related Table Products::Item) I've been playing over the weekend but I cant make into work. If I put the Catalogue Number my item its not filling...
-
Hey Guys, Thanks for having me I'm a beginner please take it easy haha! Basically I have a calculation field, where I am trying to force the answer as "0" when the calc returns "?" (due to an empty field etc, for whatever reason I'm not concerned about) My calc is: Round ( If ( I...
-
I'd thought I'd solved this but looking at the background data it's not calculating properly. Any ideas much appreciated. I have a file with a date, bottle format, total cost and converted cost for larger formats (so, for example, 75cl might cost $20 but 1.5l costs $45. The converted cost of th...
-
A little background I have a DB which keeps users logins/passwords for a business so they have all their login information for everything at work. My Issue I need the user to be able to click a button that creates a random password and places it into the password field when the button...
-
I am creating an app for a conference. Each seminar is assigned a code -- such as 101, 102, 103, etc. -- and the app will automatically create signage and displays for us. One of the services I want to provide is to tell people not only what seminar takes place right now, but which seminar will be *...
-
In Matt Petrowsky's video on all things new in Fm 16 , the very first new addition is a new calculation workspace where we can see the results of our calculation. i.e. there is an additional pane in the work space where results can be previewed.( see attached pic). I can get to this workspace f...
-
I have a TABLE::DATE field that has content with varying date types: e.g. 1) 12/12/2015 and 2) Dec 12, 2015. The field is type "Date". I have another field TABLE::c_YEAR that is of type "calculation" returning a "Number". The calculation is Year (TABLE::DATE). This works for dates as in #...
-
Hello once again I been trying to make a calculation for the conversion of weight into ml's. Normally I do this by dividing the the weight by 1.026 and the results is the amount in ml's ( 1.026 is the density of blood, plasma, serum ) I have a field for weight and another for volum...
-
Hi all, I have a requirement to re-create Quotations on a monthly basis that are fixed by a 12 month contract. On creation of the QuoteItems I want to automatically insert a fixed ID that stays with the item. Each month a new Quotation has to be produced which is then reviewed to potentially add to... -
In my solution, I have a table that lists all possible errors, and each of them have a unique ID like ERR001. I have another file containing a dictionary table with global fields that corresponds to the error messages and are filled according to the language of the user. For example, this table...
-
I can't figure out how to subtract the total of several child records from a starting value in a parent record: Sounds simple, but it's got me stumped! My database is designed to issue Emissions Reduction Credits to companies for reducing or eliminating sources of air pollution. Those compani...
