Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i need set expression to show current year data..but not effected by other selections.
Hi,
Nullify otherfield in your set analysis.
Like
Sum({<DateField={">=$(=yearstart(today()))"},Month=,Day=>}Sales)
This way you can achive currente YEar Sales regardless other selection
Hi,
Try like this.
e.g. 1. sum({<Year ={'2014'},month=,date=,product=>}sales)
2......sum({<Year ={"$(=year(today()))"},month=,date=,product=>}sales)
If your selecting the month,date,product fields then it will not reflect in the expression.
Regards,
Ajay
you Need to define those selections who shall not modify your result by "Selection=" (selection will have no effect to calculation)
sum{<year={}selectedyear},Selection1=,Selection2=,Selectionn..>}Anything
SUM({1<Year = {'$(=Year(Today()))'}>}Sales)
You do not need to qualify all fields just use the 1 set qualifier like this:
Sum({1<Year={$(=Max(YearField))}>}
Try
Sum({1<YearFieldName={$(=Year(Today()))}>} Sales)
here 1 represents ignores all selections