Jump to content

Monthly Totals without using Preview Mode

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

Recommended Posts

  • Newbies


I have FMP 7.0 on XP and am developing a magazine ad sales tracking system to tally monthly sales actuals vs budget as well as variance and variance%. I am looking for a way to do this WITHOUT using a report in preview mode/sub-summaries, I'd want to display it in browse mode WITHOUT the underlying detail.

The layout will look like a spreadsheet and have 4 columns C1:BUDGET, C2:ACTUAL, C3:VARIANCE, C4:VARIANCE%. Each column will have 12 rows, 1 for each month R1:Jan-R12:Dec.

I need the value for each column/month budget stored in a different field on the layout. The easy one was BUDGET which I have stored in 12 fields as a global value. The ACTUAL will be the actual results for a given month. The VARIANCE is a calculation field of ACTUAL-BUDGET and VARIANCE% is a calculation VARIANCE/BUDGET.

I have a simple 1 table file with 3 layouts BUDGET, ACTUAL vs BUDGET, SALES DETAIL. I have upload the file if it helps to look at.

Is there any way to do this with a single table via a calculation or custom function WITHOUT using a report in Preview mode?




Link to comment
Share on other sites


The file attached does it with only calculations and repeating fields. It was only destinated as an experiment that repeats may work with relationships too, with only calcs. So it is slow.

But you can get the principals and adapt it to get your results into each cell of a repeating field through a looping script instead.



Link to comment
Share on other sites

just make a relationship to itself then put a field with summary of which field you want to show. The portal will look to itself and show the results as you want. I use this a lot to show only the data that has similar components or parts but lay in the same table. Just set what equals what so you can pull the info from that relationship. Think open with it. Such as dates, those being similar can pull info for all records with those dates. if you match payment types, you can view only what you want that is consistant with the record you are looking at. Play with it. I use them to even filter popup lists to display only the info that catagories have.

Link to comment
Share on other sites

This topic is 6621 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.