Skip to Content
0
Jan 05, 2023 at 10:25 PM

Evaluate record for multiple conditions

80 Views Last edit Jan 06, 2023 at 04:22 PM 4 rev

Using webi 4.2:

Each record contains

webi1.png

I've created a variable, Category, using if conditions, but it only evaluates the record once. For example, ID 24 is identified as only New when it should be identified as both New and Termed.

=If [EffDate] >='1/1/2022' And [EffDate]<='12/31/2022' Then "New" ElseIf [ExpDte] >='1/1/2022' And [ExpDte]<='12/31/2022' Then "Termed" Else "NA"

I need to identify each ID as to whether the state was newly added during 2022 and also whether the state was termed in 2022 (Category). The resulting table would look like:

webi2.png

Then for each state, I need to count the number of categories and format as follows:

webi3.png

Any help in figuring this out would be appreciated.

Attachments

webi1.png (13.9 kB)
webi2.png (13.5 kB)
webi3.png (4.3 kB)