Skip to Content Former Member

### 3.1 Deski formula doesn't convert correctly to 4.1 Webi

I converted a 3.1 Deski report to 4.1 Webi using the Report Conversion Tool. The primary calculation context is not working correctly in Webi and I can't seem to get it to work.

Deski formula:                   =Sum(<Net Total 2>ForEach <Line Item Number Char>)

Converted Webi formula:  =Sum([Net Total 2] ForEach ([Line Item Number Char]))

[Net Total 2] is the last column on the right (Net Total). [Line Item Number Char] is the second column on left (L.I.). The way this works in Deski is that it sums each L.I. amount, while disregarding duplicate L.I. amounts. So in the example below, it sums 280+702+350+358.40 = 2750.80. Note: This is similar to the functionality in Crystal reports where you can use a Running Total or variables to evaluate only when the L.I. changes. In Webi, it sums all amounts (including duplicates) for a total of 3380.80. I'm not sure why it's doing this since the calculation context is the same in both tools. I can't seem to get any calculation context or formula to replicate this. Any ideas? ##### Add comment
10|10000 characters needed characters exceeded

### 2 Answers

• Former Member
Nov 03, 2015 at 10:14 PM

Just try below formula:

=Sum([Net Total 2] in ([Line Item Number Char]))

##### Add comment
10|10000 characters needed characters exceeded
• Former Member

Yes, I tried that already. It still sums the duplicates.

• Nov 04, 2015 at 10:27 AM

Hi,

use this.

=Sum(Max([Net Total 2]) ForEach([Line Item Number Char])) Amit

Untitled.png (12.4 kB)
##### Add comment
10|10000 characters needed characters exceeded
• Former Member Former Member

Hi William,

Seems like one dimension is missing from calculation context, try below and check:

=Max( ([Net Total 2]) ForEach([Line Item Number Char];[Performed By]))

Regards,

Yuvraj