highlighting

[Former Member]

Hi All,

I have a cross tab report having some summary fields.

Here I need to show symbols based on some value.

Suppose If sales value is < cost value I need to show sales value field like this  

crossmark then sales value

-3432

If sales value is > cost value I need to show sales value field like this.

Tick Mark then sales value

4333

Please help

[abhilash_kumar · Accepted solution]

Hi Divya,

Here's what you need to do:

1) Insert the same summary field to the 'Summarize fields' section of the Crosstab

2) While in the Preview Mode, right-click the first summary field > Format Field > Click the formula button beside 'Display String' and use this code:

if CurrentFieldValue < GridValueAt(currentrowindex, currentcolumnindex, 2)  then

chr(251)

else chr(252)

The formula above assumes that 'Cost Value' is also a summary field and is second summary field in the crosstab (summary indexes start from zero).

3) Right-click the summary cell once again > Select Summarized Field Labels > Select 'Summarize Horizontally'.

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

I am confusing for a sample I took amount field and need to compare with tax.

If it is more that tax then need to show Tick mark else Cross mark

PFA my report and help

Here I took sales fields 2 times and applied formula for 1st sales filed.

But I am getting error like this.

Sample.txt.zip

[abhilash_kumar · Accepted solution]

Please find attached updated report.

-Abhilash

Sample.txt.zip

[Former Member · Accepted solution]

Abhilash your Great .Always helpful.

Many Thanks