Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to develop a detailed list of claims data in a table for an insurance company. I'd like to be able to create filters so that I only show claims that have loss values greater than $10,000 and a second filter to display claims with values greater than $25,000. Can anyone help me with how best to do this? My objective is to be able to cycle through the same table but only showing claims greater than those two values.
I have attached a overly simplified version of the data
Hi,
You need to write for straight table like
Dimension -> Claim #
Dimension -> Policy #
Expression -> If( [Loss Paid] >= 10000 or [Loss Paid] >= 25000, [Loss Paid])
Rgds
Anand
Hi,
You need to write for straight table like
Dimension -> Claim #
Dimension -> Policy #
Expression -> If( [Loss Paid] >= 10000 or [Loss Paid] >= 25000, [Loss Paid])
Rgds
Anand