Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have one year filed
2014-2015
2016-2017 lik dat
i hve below exprsin used in gauge chart
Sum({<Year={$(=Max(Year))},TR_Date={">=$(vStartDate)<=$(vMonthEndDate)"},Quarter=,HalfYearFin=,Month=,Day=>}Cc_COUNT)
its working fine wen i select one year means[2014-2015] but wen i select two years both [2014-2015 and 2016-2017]
the result is not cmg with sum . only it is shwng max year values . what is the issue ? anyone trace out this?
Hi,
This is because you have written it in set analysis to get max year.
See the script part "Year={$(=Max(Year))}"
So what ever year selection you will do, it will pick up the max out of it and show the result for that year.
If you want sum for both years, then remove that section from set analysis.
Regards,
Kaushik Solanki
Hi sureshqv,
Kaushik is correct you need to remove max(year) condition in set expression and try.
thnks kaushik.
i tried below still doesnt work anymore
1) Sum({<TR_Date={">=$(vStartDate)<=$(vMonthEndDate)"},Quarter=,HalfYearFin=,Month=,Day=>}Cc_COUNT)
2) Sum({<Year=,TR_Date={">=$(vStartDate)<=$(vMonthEndDate)"},Quarter=,HalfYearFin=,Month=,Day=>}Cc_COUNT)
As i know double quotes is not the problem , Can you please share your Sample App
Hi,
Please share a sample data along with the selection which you are doing and expected output.
Regards,
Kaushik Solanki
Its nt psble. as its on server
Probably you can just give us the sample data which can replicate your problem.
Data can be anything, which shows the problem you are facing.
Regards,
Kaushik Solanki
Sum({<Year=, Month=, Quarter=, Day=, TR_Date={">=$(=Num(MonthStart(TR_Date)))<=$(=Max(vMonthEndDate))"}>} Sales)
let me try .Thanks