Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can I replace the following with variable (such as "filterValues") and resuse in other expressions:
[LOB]=$::[LOB],[Risk State]=$::[Risk State],[Claim Symbol Group]=$::[Claim Symbol Group],
[Claim Symbol SubCode]=$::[Claim Symbol SubCode],[Source]=$::[Source],
[Policy Form Name]=$::[Policy Form Name],[Writing Company]=$::[Writing Company],
[Claim Office Description]=$::[Claim Office Description],[Region]=$::[Region]>
Entire expression:
sum({1<[Calendar Year]={$(vSelectedYear)},[Calendar Month]={"<=$(=vSelectedMonth)"},
[LOB]=$::[LOB],[Risk State]=$::[Risk State],[Claim Symbol Group]=$::[Claim Symbol Group],
[Claim Symbol SubCode]=$::[Claim Symbol SubCode],[Source]=$::[Source],
[Policy Form Name]=$::[Policy Form Name],[Writing Company]=$::[Writing Company],
[Claim Office Description]=$::[Claim Office Description],[Region]=$::[Region]>
} [Claims Reported])
Have you tried this (I am not 100% certain that it will work, but worth giving it a shot)
vVar = '[LOB]=$::[LOB],[Risk State]=$::[Risk State],[Claim Symbol Group]=$::[Claim Symbol Group],
[Claim Symbol SubCode]=$::[Claim Symbol SubCode],[Source]=$::[Source],
[Policy Form Name]=$::[Policy Form Name],[Writing Company]=$::[Writing Company],
[Claim Office Description]=$::[Claim Office Description],[Region]=$::[Region]'
Save the variable with the single quotes, but without = sign.
and then use it like this:
=Sum({1<[Calendar Year]={$(vSelectedYear)},[Calendar Month]={"<=$(=vSelectedMonth)"}, $(vVar)>} [Claims Reported])