How can I calculate the sum of the joined values?

[Balazs]

Hello,

How can I add joined values? I not find this option in databasejoin plugin.

Best regards,
Balazs

 

[cheesegrits]

You mean you want to be able to add new rows to the table to which your join element is joining?

Have you tried the "Add option in front end" setting on the join element?

http://screencast.com/t/DQwSO6k0

NOTE that the table you are joining to must have a Fabrik List built from it in order to be able to do this, otherwise there is no "form" for us to pop up.

-- hugh

 

[Balazs]

I made a little imprecise. How can I calculate the sum of the joined values (e.g. 100+200+300=600). I created a new databasejoin element, and I listed company names in a bills table, and in the another element I need to show all cost which belong to listed companies.

e.g.

Companies
Company I (100$)
Company II (200$)
Company III (300$)

All cost
600$

 

[troester]

I assume you'll need the Concat field in the databasejoin element.

http://fabrikar.com/forums/index.php?wiki/database-join-element/#data
and concat field tooltips

 

[cheesegrits]

I'm still unclear. Is the companies join in a repeated group, and you want to add totals from all repeats? Or is it a multiselect join (checkbox)?

-- hugh

 

[Balazs]

I'll try summarize what I need.
I have a Companies table with this structure:

I have bills forms:

I need a solution that if I add number 2 to the project field then the Companies field is showing the names of firms belonging to the number 2 (Canon, Borther, HP). If this is done, then the companies that I selected, display
the list view and an amount of the selected companies' cost add up, and then display in the All Cost field. (600)

I tried the cascadingdropdown and the databasejoin plugins, but has so far failed me.
How do I do that?

 

[troester]

This should be possible with a databasejoin for the project, a cascading dropdown watching project for Companies and a calculation element for All Costs.
Which settings did you try so far?

 

[Balazs]

Ok, this is my configuration.

Companies (cascadingdropdown):

In list view:

So if I add number two to project field then the companies and the All Cost show a good values from Companies table, but if I choose two value (Brother, HP) and I press the Save button thereafter values show duplicate and i see Canon (+price), but I was't marked on:

 

[cheesegrits]

What is Merge set to under the Joins in list settings?

-- hugh

 

[Balazs]

I only set that appears here, all other have default settings. Exactly where and what I need to set?

 

[Balazs]

Could somebody help me?

 

[cheesegrits]

Can you answer my question?

Look under List settings, Data, Joins, at the bottom, "Display Data" ... even if you don't have any joins specified, I still need to know what this is showing as.



-- hugh

 

[Balazs]

It's works, but how can I calculate the sum of the joined values (e.g. 100+200+300=600) to one field?

 

[cheesegrits]

Can you please please please answer my question? What is the display mode set to for you Joins? Is it "Merge", or "Merge and reduce"?

-- hugh

 

[troester]

To get the sum add a calculation element
http://fabrikar.com/forums/index.php?wiki/calculation-element/

 

[Balazs]

Can you please please please answer my question? What is the display mode set to for you Joins? Is it "Merge", or "Merge and reduce"?

-- hugh

I'm sorry, I didn't read it carefully.
I use Merge.

 

[Balazs]

Any idea?