Hi

I am in contents view and have constructed a specific table with defined formulaes in each cell.

I am trying to do a red /amber /green colouring scheme to highlight numbers when they are greater than a specified level.

When i go to stylised text , then custom rules and add my own custom rules i have a few problems :

1.By default the formula in edit for which i apply this styled text rule to always is converted into text even if i leave it as a number.I have to delete the added "Text" operator in the edit formula when this is automatically added by default.How do i stop this ?
2.When i put a custom rule in styled text it works well initially when clicking off of Content view to view result .But then when i click back on content view and the formulae it says there is a error ( i.e a + operator was expected ..)
3.To overcome this i have edited the content view in html code and found a way around this (using < tdclass,... )

=30,"#ffdd00","#b1ffac")}}>

which colours the whole cell in the table (which is the preferred option instead of just colouring the text).However when i convert back to formulae mode in the content view the formatting of the table is not maintained and cells are added and deleted .If i leave the content view in html mode it work fine.Why is this, this should not occur ?
4.As a idea , could you add a coloured cell operator under the display value along with fixing the styled text function.



Other problems/Request :

1.In field operator in data manager could i have a search box added at the top much like what is availiable in the other data manager blocks as else i have to search by eye to find coloumns i want added/deleted from omniscope in data manager.

2.In bar graph is it possible to plot two fields in one coloumn so for instance if i have a field which is expected sales and actual sales i can have one bar which shows total sales and a proportion of the bar coloured which represents expected sales

3.Change coloumn names in table view .I.e when i aggregate and apply either mean/sum/formulae result accross coloumns i would like to change the name of that coloumn for that table view only to reflect whether it is sum/mean/formulae etc .
Otherwise when presenting this information in the table it gives a misleading names for the coloumn

4.Add graphs across tabs .I.e for instance say i have a content view or bar graph which i have formatted specifically in one tab i would like to add the same graph to another tab but without having to add it individually to every tab.I would like to either drop and drag view into tabs on the rhs of the main tab.Or copy and paste into views.

5.I would like to define formulae on specified views without having to create a coloumn .(I.e similar function as to measure in power pivot ) in effect to define a formulae on teh fly (Much similar to define a coloumn then using aggregate and formulae results ..)


Any help would be much appreciated

Thanks

Ben