How to get revenue bracket for the matrix?

[Anonymous]

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

[balabhaskarqlik]

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+'))))))))