Currency Comaprision

[siddharthsoam]

I have revenue in $. I need to divide this revenue in 3 categories that is tail(<$1 Mn),middle(1-5 Mn) and large(>5 Mn).

My script is as follows

Text(If(Revenue<1,'Tail',If(Revenue>5,'Large','Middle'))) as Account_type

I am comparing revenue with 1 that is a number not in currency format. This is giving me inaccurate results.

How can I compare revenue in currency format.

[sunny_talwar]

Try this

If(Revenue < 1,'Tail',

If(Revenue < 5, 'Middle', 'Large')) as Account_type

[johnca · Accepted solution]

One way is

If(Revenue <= 1,'Tail,

     If(Revenue > 1 And Revenue <= 5, 'Middle',

     'Large'

     )) as Account_type

HTH,

John

[el_aprendiz111]

Hi,

if(Money(Revenue)<1......

or

Would you be able to share a sample with the expected output?

[johnca]

You're just too fast for me Sunny 🙂