How to refer the value of one DFF Segment from another DFF Segment

Summary

DFF Segment to refer the value assigned in another DFF Segment.

Content

Hi ,

We have a requirement that a Value defined in a DFF Segment to be retrieved by another DFF Segment in the same DFF Structure.

We tried the bind variable :{SEGMENT.<Segment_Code>} and it is not retrieving the values

Example:

We have Two DFF Segments as below:

SEGMENT 1 Name: Monthly Gross Salary 

SEGMENT1 Code: MonthlyGrossSalary

SEGMENT1 Default Type : SQL Query

SEGMENT1 Default SQL Query: <Sql Query to retrieve the value. It is working fine till this part>

SEGMENT2 Name: Installments Value

SEGMENT2 Code: InstallmentsValue

SEGMENT2 Default Type :