1 Reply Latest reply: Aug 16, 2018 11:08 AM by Bala Bhaskar RSS

    How to get revenue bracket for the matrix?

    manoj annabathina

      Hi All,

       

      Please look at the attachment and I will make buckets like below

       

      I am trying like below expression, but not working

       

      If(RBYM_Revenue>0 and RBYM_Revenue>=50000,'0-50000',

         If(RBYM_Revenue>500000 and RBYM_Revenue>=1000000,'0-100000'))

       

       

      • add a filter box to select a revenue bracket for the matrix  (0-50,000, 50,000-100,000, 100,000- 500,000, 5000,000, 1m, 1m-5m,5m -10m, 10m-20m, 20m+)

       

       

      Please help me

       

      Thanks,

      Manoj

        • Re: How to get revenue bracket for the matrix?
          Bala Bhaskar

          May be this:

          (0-50,000, 50,000-100,000, 100,000- 500,000, 5000,000, 1m, 1m-5m,5m -10m, 10m-20m, 20m+)

           

           

          If(RBYM_Revenue > 0 and RBYM_Revenue <= 50,000,'0-50,000',

          If(RBYM_Revenue > 50,000 and RBYM_Revenue <= 100,000,'50,000-100,000',

          If(RBYM_Revenue > 100,000 and RBYM_Revenue <= 500,000,'100,000-500,000',

          If(RBYM_Revenue <= 5000,000,'5000,000',

          If(RBYM_Revenue <= 1,0000,000,'1M',

          If(RBYM_Revenue > 1,0000,000 and RBYM_Revenue <= 5,0000,000,'1M-5M',

          If(RBYM_Revenue > 5,0000,000 and RBYM_Revenue <= 10,0000,000,'5M-10M',

          If(RBYM_Revenue > 10,0000,000 and RBYM_Revenue <= 20,0000,000,'10M-20M','20M+'))))))))