I have got a crosstab table which has Sector in Rows and Category in the columns.
I have added a Open Document link to a sales value that appears in the body of the table, which sends the Row & Category values to the query in question.
Due to the OpenDocument link, my Sales Values that were ‘Number’ are now ‘Text’. Is there any way in which this can be avoided as I still require the value to be shown as a number?
Any help would be greatly received.
bathyphen (BOB member since 2015-06-12)
I don’t think you can make it a number, but you can modify the displayed text in several ways to make it look as though it is a number.
What does it not show that you need?
mikeil (BOB member since 2015-02-18)
Thank you for replying.
It has removed all my number formats and conditional formatting and summations of the columns at the bottom.
bathyphen (BOB member since 2015-06-12)
For the number formats, apply the FormatNumber to the numeric value to turn it into a string before using it within the html.
Apply the conditional formatting to the value rather than the entire content of the field.
You’ll need to re-do the summations by hand, using the numeric value rather than the field’s contents.
mikeil (BOB member since 2015-02-18)
How would I ‘Apply the conditional formatting to the value rather than the entire content of the field’?
I have managed to format the number by putting a round function within the document link formula, but I am unsure about how to do the above.
bathyphen (BOB member since 2015-06-12)
The Alerters are extremely flexible.
When you set one up, you can indicate which variable it should work from - and it doesn’t have to be the field it is applied to.
So apply it to the html field, based on the numeric value of the sales being over two million or whatever.
mikeil (BOB member since 2015-02-18)
Got it!
Thank you 
bathyphen (BOB member since 2015-06-12)