3.1 Deski formula doesn't convert correctly to 4.1 Webi

Nov 03, 2015 at 07:11 PM|3 Views

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