If Condition - Help

[satishkurra]

Hi

Currently i have the below if condition as Popu Up Label

if(GetSelectedCount(Project_Name)= 0 ,sum(Sales),sum(Cost))

Sales and Cost Value is ranging from values 10 - 1000

Now the change is for the Sales and Cost Value < 100, should not display the individual values but it show the label as simply < 100

But for the values > 100, should display the individual Sum(Sales) and Sum(Cost)

Can someone help me on this?

Thanks

Satish

[sunny_talwar · Accepted solution]

May be this:

If(GetSelectedCount(Project_Name) = 0,

     If(Sum(Sales) < 100, '<100', Sum(Sales)),

     If(Sum(Cost)   < 100, '<100', Sum(Cost)))

[satishkurra]

Thanks Sunny. It worked...