Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
)))))
Is this an expression inside a variable? If it is, then you can read about this here Variables with Parameters
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