Skip to Content

Capturing Values from Cross Tab

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

Add comment
10|10000 characters needed 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

    position-cross-tab2.png

  • Get RSS Feed

1 Answer

  • 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?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded