Skip to Content
0
Jun 04, 2020 at 09:45 PM

Sum values from table and get result out of the table

169 Views Last edit Jun 04, 2020 at 09:46 PM 2 rev

Hello, I have a table like this in SAP WEBI with some dimensions and an measure that validate if a record is relevant ( =1 ) or not based on many if rules (all in the same variable)

What I wanna do is to graph the number of relevant tests basen on values [Relevant] = 1, but when I drop the formula in the report I got a multi value message because there are more than one unique record to evaluate.

How can I do the sum for all the values in the query?, I mean I need that the formula that evaluate individual records return me the sum of all matches records.

Attachments

cc.png (20.3 kB)