Comparing points between 2 metrics in script ...

[#1]

So..I have 2 metrics as below

Target : 3.8

Actual : ((sum(Cost * 100)/sum(Revenue)))

and below is my metrics...I am messing up with  parentheses here..can anyone help me..

if((sum(Cost * 100)/sum(Revenue)) < = '3.8',5,

if(((sum(Cost * 100)/sum(Revenue)) > 0 and (sum(Cost * 100)/sum(Revenue))) <= '4',3,

if((sum(Cost * 100)/sum(Revenue)) > '4.1' ,1 ))) as [Real Estate  Rate]

Thanks much

[Anil_Babu_Samineni]

Can you please let me know

You want Cost * 100 of sum OR Sum(Cost)*100 ??

[vishsaggi]

May be this:

= if((sum(Cost)/sum(Revenue)) * 100 <= 3.8, 5,

if((sum(Cost)/sum(Revenue)) * 100   >  0 and (sum(Cost)/sum(Revenue))*100 <= 4, 3,

if((sum(Cost)/sum(Revenue)) * 100   >  4.1 ,1 ))) as [Real Estate  Rate]

[sunny_talwar]

This seems like something which is done in the script... because of the as [Real Estate Rate]. Are you using Group by?