Skip to Content
avatar image
Former Member

WEBI Formula Question

Hello,

I need to bring last month's Product's Ton values according to the Product as below. My problem is that values are being summed for all months, it is cummulated. But my aim is only bring the latest month values.

I have Month, Product dimensions and Product Ton measure.

My source data is BICS from BW.

I am using 4.1 SP4.

Data is coming like below firstly.

After I used formulas, result is seeming as cummulated by summing other months' values.

My Product Formula is   = ([Product] where ([Month] = (Last([Month]))))

My Moth  Formula is      = Last([Month])

I want to see like this.

Can you help me, please?

Best Regards,

Tarumar

1.jpg (34.3 kB)
2.jpg (12.8 kB)
3.JPG (13.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 23, 2014 at 09:32 AM


    pastedImage_0.png (21.3 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sujitha,

      Your formula and Rogerio's formula are working well.

      Thank you very much.

      Best Regards,

      Tarumar

  • avatar image
    Former Member
    Dec 23, 2014 at 09:31 AM

    hi, try Sum([your measure] where ([month]=(Last([month]) In Report)))

    cheers,

    ROgerio

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Rogeria,

      Thank you very much. Your formula and Sujitha's formula work.

      My Best Regards,

      Tarumar