Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created straight table to show sales of current month,for that i have used expression
=Sum ({$<Year ={$(=YearName(max(Date)))},>} Sales)
But i want to show the label as "current year-year" means if i select 2016 the label should be "current year-2016"
for this what should i write in label???
Thanks!!!!!!!
try this
'Current Year'&GetCurrentSelections(year)
Hi Arul
that syntax is not working
=Current Year - ' & Year
or
=Current Year - ' & GetFieldSelections(Year)
, will also work
Hi Giridhar,
You can also try this below expression.
='Current Year' & Max(Year)
or
='Current Year' & Year
try this
Current Year - ' & Max(Year)
do you have year filed?
if you dont have
try creating year in script
year(date) as year
Perhaps This,
VYear = YearName(max(Date),'YYYY')
VYear1 = Sum ({$<Year ={'$(VYear)'},>} Sales)
='Current Year' & '$(VYear1)' & ' ' & GetFieldSelections(Year)
For me This is Working(Try Same Expression)
='There were no sales in the months of ' & Concat(distinct {1<Start_Month=E({$<Start_Month={"=sum(DISTINCT PaidWithTax)<>0"}>}Start_Month)>}Start_Month,',',Num(Start_Month))
&' '&'for '&GetFieldSelections(Shop)