Jump to content

Show Summary of Value List Items


wallaby
 Share

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

Recommended Posts

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

Link to comment
Share on other sites

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")

Link to comment
Share on other sites

This topic is 5722 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
 Share

×
×
  • Create New...

Important Information

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