Skip to Content

Capturing Values from Cross Tab

Mar 01, 2017 at 09:42 AM


avatar image

I have created the following Cross tab


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


10 |10000 characters needed characters left characters exceeded

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


* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Mar 01, 2017 at 01:24 PM

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?


Show 1 Share
10 |10000 characters needed characters left characters exceeded

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