Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
MRitter
Employee
Employee

What is this actually doing?

Count(TOTAL <$1> {<Year={"$(=Min(MinYear)+4)"}>} ClaimID)

I don't understand the impact the <$1> is having.

This is the actual entire statement.  I did not create this and want to understand it.

Thanks

If(Count(TOTAL <$1> {<Year={"$(=Min(MinYear))"}>} ClaimID)<>0,
Count(TOTAL <$1> {<Year={"$(=Min(MinYear))"}>} ClaimID),
If(Count(TOTAL <$1> {<Year={"$(=Min(MinYear)+1)"}>} ClaimID)<>0,
Count(TOTAL <$1> {<Year={"$(=Min(MinYear)+1)"}>} ClaimID),
If(Count(TOTAL <$1> {<Year={"$(=Min(MinYear)+2)"}>} ClaimID)<>0,
Count(TOTAL <$1> {<Year={"$(=Min(MinYear)+2)"}>} ClaimID),
If(Count(TOTAL <$1> {<Year={"$(=Min(MinYear)+3)"}>} ClaimID)<>0,
Count(TOTAL <$1> {<Year={"$(=Min(MinYear)+3)"}>} ClaimID),
If(Count(TOTAL <$1> {<Year={"$(=Min(MinYear)+4)"}>} ClaimID)<>0,
Count(TOTAL <$1> {<Year={"$(=Min(MinYear)+4)"}>} ClaimID),0
)))))

2 Replies
sunny_talwar

Is this an expression inside a variable? If it is, then you can read about this here Variables with Parameters

MRitter
Employee
Employee
Author

Yes, this is in a variable.  That helped me understand better.

What I am trying to do is make this chart unresponsive to any filters.  This variable is the denominator in an expression.  Everything that I have tried so far doesn't work.

The total expression is

(If (Year = Max(MaxYear),Count({<Industry=,Year={"<=$(=Max(MaxYear))>=$(=Min(MinYear))"} >} ClaimID) * vPercLeft,
Count({<Industry=,Year={"<=$(=Max(MaxYear))>=$(=Min(MinYear))"} >} ClaimID))
/
$(vTotalTrendDenominator(Actions)))-1

The expression I included in the first post is vTotalTrendDenominator

Thanks