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 the 1.5l is $22.5). Assuming one beverage and just one bottle of each, I want to output a report which looks at the costs and converted costs over a specified period (eg 1/1/2016...12/31/2016) and outputs a 'premium' for, say, the 1.5l bottle.
In this example, let's say I have 6 records:
date1 75cl $19
date2 75cl $19.5
date3 75cl $20
date4 1.5l $43
date5 1.5l $45
date6 1.5l $48
Then searching between date1...date6 would give etc.
However, it is not working out the totals correctly eg it is not calculating the premium properly for the 1.5l format - it appears to group all of the values together.
By Cynthia Heyman
I have a layout where it shows a Person's information (name address etc), and it includes a Tab Control that lists all the dogs that are related to (owned by ) that particular person.
I want to be able to click on a button that allows the user to add a new dog that is connected to the person showing. I have a Dog Details layout, I just need to pass the person key/information to the Dog Details layout so the dog is automatically added to that person.
I've attached a screenshot of the Person Details layout with the Tab Control, and the Dog Details layout, where I'd like to have the Owner field automatically filled in when added a new dog.
In my button control, I've tried a Single Step and the Go To Layout, and adding the Optional Script Paramater, using the Primary Key from the People Table, but it doesn't seem to be working.
I'm very new at this and I'm sure there is an easy solution for those experienced users.
By rick altman
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 *next up* in a particular ballroom. I have created a field called Next, into which we would enter the code for the seminar that takes place next, but that's as far as I have gotten. How do I automatically gather the information?
For instance, let's say that Seminar 101 is entitled "How to Think," and is being led by John. Next up in that room is Seminar 103, entitled "How to be Great," led by Jane. I want to create a calculated field that would be part of 101's record that would automatically pick up title and speaker from 103's record.
How would I do that??
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 from the Data Viewer , but when I try to get to it from Define Fields dialog box, I just get the regular calculation workspace.
What Gives ? Why is it not everywhere ?
Got a real strange issue....
My button bars look fine, slightly offset, but fine on the desktop version... But as soon as I look on FM Go, one of the text boxes just floats away? - I have tried moving it around and changing the size and i just get the same issue but with different buttons?