Capturing Values from Cross Tab

[Former Member]

I have created the following Cross tab

position-cross-tab.png

I need to capture all the Negative Totals for each currency. I can do this within a Manual Cross Tab but would like to avoid doing that if possible, Is it possible with a conventional cross tab.

I am using CR2013 on Oracle.

Thank you

Ian

[Former Member]

I right clicked one of the total values and selected

-> Embedded Summary

-> Insert Embedded Summary and it added Edit this formual to every cell see attached image

I then tried adding following formula without any success. Am I on right lines or going completely the wrong way!!

Global NumberVar Position;

If Tonumber(GridRowColumnValue ("Total")) <0 Then

Position := Position + Tonumber(GridRowColumnValue ("Total"))

Else Position := Position

But got following Error

Highlights first "Total"

This is not the name of a grid group for the field being formatted

position-cross-tab2.png

[abhilash_kumar]

Hi Ian,

Are you trying to sum up all negatives and display somewhere outside the crosstab?

Or are you trying to display currencies with a negative total?

-Abhilash

[Former Member]

I need to sum all negative values and report in another summary. So need to capture as a variable

Ian