Simplifying a nested if expression

[#1]

Hello

This expression of mine is trying to calculate 12 months rolling but is not coming out correctly.

If anyone can change this expression it would be helpful

If([Currency]='Transactional',

       Sum ($(vfsa-Deferred Revenue)If([GL Date] >= date("$(=[End Period])"+12) and [Initial Entry Flag]='N'and [Schedule Created End Date] < date("$(=[End Period])"+12) and [Schedule On Hold]='N' ,[Net Amount],0)),

       If([Currency]='Functional',

               Sum ($(vfsa-Deferred Revenue)If([GL Date]>= date("$(=[End Period])"+12) and [Initial Entry Flag]='N'and [Schedule Created End Date] < date("$(=[End Period])"+12) and [Schedule On Hold]='N',[Net Amount Operating Currency],0)),

               If([Currency]='Reporting',

                       Sum ($(vfsa-Deferred Revenue)If( [GL Date] >= date("$(=[End Period])"+12) and [Initial Entry Flag]='N'and [Schedule Created End Date] < date("$(=[End Period])"+12) and [Schedule On Hold]='N',[Net Amount Reporting Currency],0)),0

   //                    Sum ($(vfsa-Revenue)If([GL Date]>= $(=[StartPeriod]) AND [GL Date]<= ($(=[EndPeriod])+12),[Net Amount],0))

               )

       )

)

Thanks

[#2]

Vfsa-Deferred Revenue is nothing but a variable that has a condition stored

behind it

(='DEF or ='EITF DEF')

Thx

On Mon, Mar 17, 2014 at 2:34 PM, Ajay Prabhakaran