cancel
Showing results for 
Search instead for 
Did you mean: 

Sum Function Issue

harsha_ganapathy
Participant
0 Kudos

Hello All,

Need quick help on getting sum functionality. Guess a context issue but still unable to figure out the solution

I have created a variable which gives me sum(v1+v2) foreach Dimension-A

I have another Dimension B.

sum(v1+v2) foreach Dimension-A = XX -->224


sum(v1+v2) foreach Dimension-B= XY -->308


All I need is to display in report is sum(v1+v2) which is XY



In report, All i need to see is 308. When I just drag sum(v1+v2) foreach Dimension-A still I get 224.


How to get this.


Thanks,

Harsha

Accepted Solutions (0)

Answers (2)

Answers (2)

arijit_das
Active Contributor
0 Kudos

Did you try :

=Sum( ([v1]+[v2]) ForEach ([Dimension-B]) )

harsha_ganapathy
Participant
0 Kudos

Yeah Arijit.

Its done and its of no help

Former Member
0 Kudos

Hi,

I´m sorry but I didn´t understand your question, can you provide us with some sample data ?

You don´t need to redefine the context if A and B are in the same block of the sum(v1+v2).

You need to use the ForEach if A or B isn´t in the block.

Regards,

Rogerio

harsha_ganapathy
Participant
0 Kudos

Rogerio,

Now, there are no Dimensions. Only Sum needs to be displayed in a individual cell.

I need 308 to be displayed

Also, below 2 fields are in 2 report tabs.

Tab 2------- sum(v1+v2) foreach Dimension-A -->224


Tab 1------- sum(v1+v2) foreach Dimension-B-->308



Now, in Tab 2, in a single cell  I need 308.

Thanks,

Harsha

Former Member
0 Kudos

Hi,

I mean, what are the dimensions that lead to the sum of 308?

Regards,

Rogerio

harsha_ganapathy
Participant
0 Kudos

Rogerio,

That is related to Dimension Area (B)

Sum (field) for Dim A - 224- Present in report tab 2

Sum (field) for Dim B - 308 - Present in report tab 1


Thanks,

Harsha

Former Member
0 Kudos

Hi,

try using Sum(field) In ([B]) instead.

Regards,

Rogerio

harsha_ganapathy
Participant
0 Kudos

Tried then Rogerio.

Not working. Foeach, ForAll and In Report. None of them are working