Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
If(GetSelectedCount(Project_Name) = 0,
If(Sum(Sales) < 100, '<100', Sum(Sales)),
If(Sum(Cost) < 100, '<100', Sum(Cost)))
May be this:
If(GetSelectedCount(Project_Name) = 0,
If(Sum(Sales) < 100, '<100', Sum(Sales)),
If(Sum(Cost) < 100, '<100', Sum(Cost)))
Thanks Sunny. It worked...