Skip to Content
avatar image
Former Member

Scenario for count growth% which having negative values

Hi Experts,

  i want a formula for count,below i explain the scenario,

Cust Field Cal yr/mon Field Growth % 131383 04.2013 -100 131383 04.2013 78 131383 04.2013 99 131383 04.2013 19 131383 04.2013 73 131383 04.2013 54 131383 04.2014 87 131383 05.2013 23 131383 05.2014 34 131383 06.2013 45 131383 06.2014 67 131383 07.2013 78 131383 07.2014 34 131383 08.2013 23 131383 08.2014 34 131383 09.2013 67 131383 09.2014 34 131383 10.2013 34 131383 10.2013 34 131383 10.2014 45 131383 11.2013 -34 131383 11.2014 -45 131383 12.2013 -56 131383 12.2014 -65 131383 01.2014 -23

i want to count growth% of only current cal/yr month(04.2014 to 12.2014) which having negative values except 01.2014 for all customers.please

help me in this regard....

Result should come like

Cust          Count

---------------------------------

131383          2

Thanks.

Ashwin

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 02, 2015 at 07:03 AM

    Hello Ashwin,

    Please try the below scenario:

    Create two variables, refer the below image (sign and count).

    Using the count variable you can display the count of Growth% which are having negative values(like 2nd block in 2nd image).

    But I am not sure, what business you are applying here to filter the date (4.2014 to 12.2014). Is this any user input values or last 3 quarters in Cal.Year.

    Here I have filtered the the data by using a block filter between 4.2014 and 12.2014 (1st block in 2nd image)

    Variables:


    Display:

    Please let me if it helps..

    Regards,
    LKumar


    Display.JPG (27.9 kB)
    Variables.jpg (153.9 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Hello Ashwin,

      I didn't get the exact requirement mentioned above that 'restrict year month between with in fiscal year'.

      Do you want to display only Year in the column Cal yr/mon field without specifying yr/month like below :

      Field data from source     yr/mon Field

                                                  4/1/14


      You want to display       yr/mon field

                                                 2014              

      Let me know if I am wrong in the above requirement..                       

      Regards,

      LKumar