Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In my dimension data there are negative value (-7 to -1), and then '0' onwards, i would like to group -ve value as one group, call it '-ve' and would like to take rest dimension as is in axis.
May be use this
If(Len(Sum(Sales))<0, '-ve', rest) as Dimension
Then use Calculation as per your need
Hi Pankaj,
Check this also
if(num(Dim)<0,'-Ve',Dim) as Dim
for your practice
=if(num(-5)<0,'-Ve',5)
Try like this
if(sign(sum(sales))=-1,'Negative','Positive') as Dim
in the front end expression
If(Sum(Sales)<0, '-Ve', Sum(Sales))
//script
if(Sales<0,'-Ve',Sales) as Sales_New