AVD128 Posted January 2, 2007 Posted January 2, 2007 Hi, I am looking for a calculation which can create a value list from a found set or a relation, which I can use for a input of xmCHART. Example Record 1 Flied data = [12 ] Record 2 Flied data = [9 ] Record 3 Flied data = [17,8] Record 4 Flied data = [0 ] Calculation flied = [12 9 17,8 0] [color:red]I want to use it to draw a graph without triggering a script!
Ender Posted January 2, 2007 Posted January 2, 2007 Try a CF using GetNthRecord(), like this: http://www.clevelandconsulting.com/support/viewtopic.php?t=637
AVD128 Posted January 2, 2007 Author Posted January 2, 2007 Nice !? How / where can I order those custom functions, or is it freeware ?
Søren Dyhr Posted January 2, 2007 Posted January 2, 2007 It's DIY and free - Just enter the text found in the code box into a newly created customfunction build found in File>Define>customfunction, inspect the namings and apply them to correct locations. --sd
comment Posted January 2, 2007 Posted January 2, 2007 If your data is coming from a related set, you don't need a custom function for this. A calculation (result is Text) = Substitute ( List ( Related::Field ) ; ¶ ; " " ) should return the indicated result.
AVD128 Posted January 2, 2007 Author Posted January 2, 2007 THKS !! Works Excellent!! !! [color:green]FileMaker For Everyone !!
Recommended Posts
This topic is 6535 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 accountSign in
Already have an account? Sign in here.
Sign In Now