Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a straight table with various expressions for current year, previous year and before previous year.(Total days for current year,Total store for current year .....)
total days expression-
current year expression
=num(count({< year = {"$(=Max(year))"}>}DISTINCT Sold_Date),'#,##0.0')
previous year expression
=num(count({< year = {"$(=Max(year)-1)"}>}DISTINCT Sold_Date),'#,##0.0') as so on....
Now I want to make some changes in the report ie on selection from Ist multi box(i have selected 2017 ) I should get value of 2017
when I select for 2nd multi box like 2017 , the data should be selected for 2017 (can be seen in mage ).
so what changes should i do in expression and how to maintain alternate state for three different multibox?
Hi Saksham,
You can create a state in the multibox and assign the state to the multibox so the value changes for the respective state.
Many Thanks
Karthik
Following is the expression to calculate growth%
Num(((sum({<year = {"$(=Max(year-1))"}>} [inv value] / Sales_INR_Unit) -
sum({<year = {"$(=Max(year)- 2)"}>} [inv value] / Sales_INR_Unit)) /
Sum({<year = {"$(=Max(year)- 2)"}>} [inv value] / Sales_INR_Unit) * 100), '#,##0.0')
but now I want when user selects 1st multibox(sales date for before previuos year as 2017) and when user selects 2nd multibox(sales date for previuos year as 2016) and when user selects 3rd multibox(sales date for before current year as 2017) the growth% should be calculated on basis user selection (i have maintained states for the above situation). I want what changes should i make in my growth% expression so that it can work on users selection ?
=Num(sum(if(GetCurrentSelections(<{StateB<Year=$::Year,Month=$::Month>} [inv value] / Sales_INR_Unit) -
sum({StateA<Year=$::Year,Month=$::Month>} [inv value] / Sales_INR_Unit)) /
Sum({StateA<Year=$::Year,Month=$::Month>} [inv value] / Sales_INR_Unit) * 100),'#,##0.0')
Following Expression is giving an error