Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have straight table with custom error message " Select one dimension to see data".Some how after each reload the error message is getting replaced by following.
"Error in set modifier ad hoc element list:
',' or ')' expected"
I do have calculation condition as Getselectedcount(Dimenison)=1 or 2.why my custom error message is changing?
Thanks in advance
I think ..it is because of missing of ')' in set expression.
Can you please share your set expression?
Regards
Harsha
Some of your expressions is not ok.
Would you mind sharing your expressions?
Sorry for late reply.I am using following expressions.
=Only({<Type=,[Week]=,[Week Counter]={$(=$(=vSelectedWeek)-2)}>} SaleNumber)
=Only({<[Week]={$(=max([Week Counter]))}>} SaleNumber)
=Only({<Type=,[Week Counter] ={$(=max([Week Counter])-2)}, [Week Range] =>} [Week Friday])
What is the content of vSelectedWeek?
Should the expression use $(vSelectedWeek) not $(=vSelectedWeek)
=Only({<Type=,[Week]=,[Week Counter]={$(=$(vSelectedWeek)-2)}>} SaleNumber)
In Script i used Dual (WeekRange,WeekCounter) .So whenever I select week range ( Ex:0803/2015-08/07/2015) in UI vSelectedWeek gives respective Week Counter.
A good trick to start with: enable these expressions one-by-one to see which one is causing issues.
Peter
I tried it too but no luck