Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The following will return data when the line : FY_Period = {"<=$(=vFYPeriod)"}>},
is NOT used.
The variable FYPeriod is numeric and is defined as =Max( distinct FY_Period) and I tried without distinct
The aim is to return records for a particular year, up to and including the period , so currently period 11, which is March 2014 in the example since we are taking 1 from the FY.
=if(Vcurr='STG',
num(Sum ({<
FY={$(=vFY-1)},
FY_Period = {"<=$(=vFYPeriod)"}>},
product_group_a -= {'BMX','BPN','BSF','BST','BPI'},
SalesCat = {'MDE','MAT','MNL','M/O','IRL','MBE','MDK','MSE','MFR','MLU','PUN','VBN','SBM'}>}
val_base),
'£#,##0.00'),
num(Sum ({<
FY={$(=vFY-1)},
FY_Period = {"<=$(=vFYPeriod)"}>},
product_group_a -= {'BMX','BPN','BSF','BST','BPI'},
SalesCat = {'MDE','MAT','MNL','M/O','IRL','MBE','MDK','MSE','MFR','MLU','PUN','VBN','SBM'}>}
val_eur),
'€#,##0.00'))
Hi
I am not an expert in set analysis, but I did notice that your expression FY_Period = {"<=$(=vFYPeriod)"}>} has 2 closing curly brackets } but only one opening {. I have a feeling that cannot be correct.