Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have declared a variable vYear_Quarter as follows
=if(vSelectionValue = 2017,'2017/Q1, 2017/Q2, 2017/Q3, 2017/Q4',
if(vSelectionValue = 2018,'2018/Q1,2018/Q2'))
The above expression returns vYear_Quarter = 2017/Q1, 2017/Q2, 2017/Q3, 2017/Q4 if I select year 2017 and
vYear_Quarter = 2018/Q1,2018/Q2 if I select year 2018
.But I want to get the value vYear_Quarter in a such a way that it could be fed to a set expression
=sum({<"YearQ"={'$(vYear_Quarter )'}}>}AMOUNT)
But with the if statement i am not able to get the value of vYear_Quarter in the form such as '2018/Q1','2018/Q2'
I want 2018/Q1 and 2018/Q2 in apostrophe and seperated by comma
Try this may be
=If(vSelectionValue = 2017, Chr(39) & '2017/Q1' & Chr(39) & ',' & Chr(39) & '2017/Q2' & Chr(39) & ',' & Chr(39) & '2017/Q3' & Chr(39) & ',' & Chr(39) & '2017/Q4' & Chr(39),
If(vSelectionValue = 2018, Chr(39) & '2018/Q1' & Chr(39) & ',' & Chr(39) & '2018/Q2' & Chr(39)))
Try this may be
=If(vSelectionValue = 2017, Chr(39) & '2017/Q1' & Chr(39) & ',' & Chr(39) & '2017/Q2' & Chr(39) & ',' & Chr(39) & '2017/Q3' & Chr(39) & ',' & Chr(39) & '2017/Q4' & Chr(39),
If(vSelectionValue = 2018, Chr(39) & '2018/Q1' & Chr(39) & ',' & Chr(39) & '2018/Q2' & Chr(39)))
Amazing