Cross Tab Grid Value

[Former Member]

Hello Everyone ,

I have an issue in Creating a field  from  formula depending on 2 fields inside Cross tab ...

The field i need is as Follows :  If {net value} > {Last Number}  Then { Net Value }  Else 0  ...  I need this field for every date  Any Help  ?

Thanks in Advance

[abhilash_kumar · Accepted solution]

Hi Said,

Here's what you need to do:

1) While in the Preview Modem, Right-click the summary value under "Last Number" and select Embedded Summary > Insert Embedded Summary.

2) You should see a text called 'Edit this formula' beside the "Last Number" field in all columns.

3) Right-click the text and select Embedded Summary > Edit Calculation Formula and use this code:

if gridvalueat(CurrentRowIndex, CurrentColumnIndex, 0) > gridvalueat(CurrentRowIndex, CurrentColumnIndex, 1) then

gridvalueat(CurrentRowIndex, CurrentColumnIndex, 0)

else

0

Hope this helps.

-Abhilash

[Former Member · Accepted solution]

Thanks Kumar  ... worked