I have a table on my dashboard with values of orders and requests. And I want to compare these two values using backward color and a filter. My code with backward color works fine but I have problems with adding a filter pane. Now I have this:
=if(((([Order Value])-([Request Value]))/(([Request Value])))<=-0.3,'less than request on 30%', if(((([Order Value])-([Request Value]))/(([Request Value])))<=-0.1,'less than request from 10 to 30%', if(((([Order Value])-([Request Value]))/(([Request Value])))<=0.1,'don't differ from request more than 10%', if(((([Order Value])-([Request Value]))/(([Request Value])))<=0.3,'more than request from 10% to 30%', 'more than request on 30%'))))
And when I use my filter to the table it shows me right values and some not the right ones. I can't understand why this is happening. Really need your help!
As example: I use filter pane that should show me orders that are less than requests on 30% and more. I when I click this filter it shows me right cases and also cases when orders more than requests or equal to them
if((([Order]-[Request])
/([Request]))<=-0.3,'less than request 30%',
if((([Order]-[Request])
/(([Request])))<=-0.1,'less than request 10 to 30%',
if(((([Order])-([Request]))
/([Request]))<=0.1,'do not differ from request more than 10%',
if((([Order]-[Request])
/([Request]))<=0.3,'more than request 10% to 30%',
'more than request 30%'
)))) as NewFieldName
and then use NewFieldName as your filter object....
