Hi, I have different products say A,B,C etc.. I have requirement to have A , B and c is the new field value that should have the data with the sum of A and B. How do we do this ?
Hi, I have given groupement details in a table .. Eg : Amelia,surpharm,totalfrance, rostra, zentiva are the field values in a FIELD called GROUPEMENT. So the user is making selections on field values and the data is coming correctly . Recently we added a totalfrance field value where it should contain the data for both summing up Amelia and surpharm when totalfrance is selected in listbox.
Probably the best way to achieve this is to create another grouping field, associated with GROUPEMENT, which associates totalfrance with the two GROUPEMENT values that you require. The other GROUPEMENT values in the new group would simply associate with the same value.
Thanks for the input . So this will sum up the data for total France but I should be having the other groupement as well separately . Please guide me on this scenario as well ?
Not sure what you mean. Do you want to be able to select the components of totalfrance separately? Then you will need 2 listboxes, one for each of the groupings.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Hi, Actually I would like to have the “totalfrance” field value along with zentiva,anemia,suropharm etc in the same listbox. We don’t have any data for totalfrance. But it should show the data for sum of anemia and suropharm when selected from listbox.
LOAD * Inline [ GROUPEMENT, NEW_GRPOUPEMENT rostra, rostra zentiva, zentiva totalfrance, totalfrance // Should contain both sum of AMLEIA and SURPHARM data Amleia, // AMELIA OLY surpharm, t// SURPHARM oly ...add more... ];
