cancel
Showing results for 
Search instead for 
Did you mean: 

Sum of two different blocks in Webi

Former Member
0 Kudos

I have a webi crosstab report in which there are product and charges for each of the products for all the months in a year.

I created another data provider and merged using months column and placed the block using relative positioning in the same report.Now when i do sum of these two blocks the sum is not calculated correctly.FOr eg., I created a variable like var1=sum(charge) In Block and var2 = sum(tax) in block. When I do sum of var1 + var2 it is not correct.

can someone suggest the right syntax please?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Do these tax and charge are both available on both the queries, if yes, try separating in formula like [Query 1] .[tax] and [Query 2].[Charge]

Dinesh