In the below expression I am trying to calculate 12 months or 12 periods from my chosen period. But it is not coming out correctly. Is there a way to simplify this expression to get what I am trying to do.
If([Currency]='Transactional',
Sum ($(vfsa-Deferred Revenue)If([GL Date] < date("$(=[End Period])"+12) and [GL Date] >= "$(=[Start Period])" 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 [GL Date] >= "$(=[Start Period])" 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 [GL Date] >= "$(=[Start Period])" 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))
