set analsis expre

[Anonymous]

AVG (field)

where
field1= 'some value'

AND (field2 = 'some value'OR field IS NULL)

AND field <> 'NA'

this needs to be done on set analysis

how?

[Anonymous]

but we are required to do calculations at front end as creating a dynamic variable for dates as well.

[Anonymous]

its a urgent requirement ,can you please help with the syntax for set analysis for the above ,

[Anonymous]

hi sunny

set nalysis expert,kindly help.

field1='value' and (field2='NA' or isnull(field3)) and field4<>'NA' and (field5<>'null' or field6<>'null')

[sunny_talwar]

I suggest creating a flag in the script for doing this

If(field1='value' and (field2='NA' or isnull(field3)) and field4<>'NA' and (field5<>'null' or field6<>'null'), 1, 0) as Flag

and then just this

{<Flag = {1}>}

[Anonymous]

thanks sunny ,will try that

[Anonymous]

I tried with the above solution,

but its not giginvg me the correct result

why?

[sunny_talwar]

I have no idea what you have and what you tried.... so it will be difficult to say why... you will have to share more to get an answer to your why