Set Expression Issue

[vinod2086]

Hi,

Can any one help me to write set expression based on the following.

                -  Level = critical

                - Submission date - report run date > 7.0 days

                - Status not equal to closed

                - Intermediate Control Measure not equal to Yes

Thanks in Advance.

[prat1507]

Maybe this

Sum({<

Level={'Critical'},

Submission date - report run date ={'> 7.0'},

Status-={'Closed'},

[Intermediate Control Measure]-={'Yes'}

>}

Value)

Regards
Pratyush

[saniyask]

Hi,

Please refer to the below blog.

Dates in Set Analysis  and Set Analysis: syntaxes, examples

Regards,

Saniya.

[agigliotti]

I suggest you to create a new field in your script as below:

(Submission date - report run date) as Date_Diff

then

Sum( {< Level = {'Critical'}, Date_Diff = {'>7'}, Status -= {'Closed'}, [Intermediate Control Measure] -= {'Yes'} >} Value)