Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Show Summary of Value List Items

Featured Replies

Hi

I'm new at FM and I'm blocked again. I didn't find a solution so far, regardless what I tried. And after searching fmForums 3 days, I thought I'll give it a try. May be it's very simple and I'm just looking too far?

I have a Value List filled with different Items (in my file called "Kostenstellen").

My idea is to have now on the "Matrix"-Tab a Summary, where it pulls out all Items from the Value List once and shows also on the left side the total of the Costs (total from "AUS Zahlenwert").

Additional: Best would be of course if I could add a search to show it by years (lets say 2006) like I made on the Tab "Listen", where I can sort/filter by month/years.

So far I haven't been able to even get out the Value List into a Portal or Textfield. Is that possibe from a Value List? If yes, how?

I hope my english was clear enough? :)

Thank you very much for your help.

_ValueList.zip

Your ValuelistItems field (gTEST) had the wrong information. First you want your calculation to return text, not a number. Second you originally had:

ValueListItems ("Kostenstellen AUS" ; "Value Kostenstellen Aus")

Should be:

ValueListItems("_ValueList";"Kostenstelle Value AUS")

or

ValueListItems(Get(FileName);"Kostenstelle Value AUS")

  • Author

Oh, yes, that was it :) Thank you very much, sbg2.

Now I just need to see how I can get the total summary of the appropriate ListValue.

Thank you very much again, sbg2.

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.