Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to understand how to find values based on these criteria. How can I create a formula in Expression to show the following:
Report 1 will include ABC Auto Insurance only.
Report 2 will include both ABC Auto Insurance and 123 Home Property Insurance.
Report 3 will include both 123 Home Property Insurance and Public Auto Insurance.
Retailer ------------------------------Written Business in POR ----- Written Business in BOS ------ Written business in CHA
ABC Auto Insurance -----------------------YES-------------------------------------NO----------------------------------NO
123 Home property Insurance---------YES--------------------------------------YES----------------------------------YES
Public Auto Insurance---------------------NO-------------------------------------YES-----------------------------------YES
Your expression would be some sort of aggregation function, like count of policies. Use a set definition in the function to limit the Retailer values. Like:
Count({<Retailier={'ABC Auto Insurance'}>}PolicyNo)
Count({<Retailier={'ABC Auto Insurance', '123 Home property Insurance'}>}PolicyNo)
-Rob