Need help on adding multiple row values into one value 1

[toblerone65]

Hello everyone, need some help to build a logic formula.

I have 3 groups and sample data as below
GH1 CA
GH2 Santa Barbara
GH3 94015
Det 10 S RA
20 A PA
30 S JA

where ever I have Value as S in second column, i need to sum up those values separated by / and show data like below


10 S RA/JA
20 A PA
30 S RA/JA



Any help will be greatly appreciated.

 

[xxyyzz49]

Not exactly sure what you are looking for but take a look at running total fields and evaluate based on a formula. If this is way off please clarify what you need a bit better please.

 

[Charliy]

Are the 10 and the 30 affecting each other, or is there other data we're not seeing? If 10 has the /JA because 30 has an S, then I don't see a way to do it without subreports.

 

[fisheromacse]

i may be WAY off, it is the 4th Monday of the week and I have not completed a single cup of coffee yet today, so apologies if i totally missed it.

if your report can be changed to add a group on the 'S'/'A' field, you could suppress the details section and display data in the Group Footer 4 (S-A Value Field)
use a formula in the suppressed details to combine your fields and a second one in the GF4 to display them. something sorta like:

//{@Combine}
stringvar sv;
IF {table.SAValueField} = "S" then sv := sv & "/" & {table.RAJAValueField} else sv := sv;

//{@Display)
stringvar sv;
sv

You would still need to place the real table/field names for {table.RAJAValueField} in the RF4 on top of the display formula, and then set suppression criteria for both the database field and the display formula so that only the appropriate one was shown.

 

[toblerone65]

Thank you fisheromacse , a very good idea.