Skip to Content
avatar image
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

  • Get RSS Feed

2 Answers

  • avatar image
    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

  • 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