set modifier expression error !

[#1]

Hi Community,

i have this formula on an simply texfieldobject:

=num(
    100 - (
        Count(DISTINCT{ < FIELDVALIDATION={'invalid'} > } [HEL_DATA_Flight ID]) /
        Count(DISTINCT [HEL_CAMPAIGN_Flight ID]) * 100),
        '0,000'
    ) & ' %'

this works very fine. But now i want to expand the condition from

FIELDVALIDATION={'invalid'}

to

FIELDVALIDATION = {'invalid'} AND NOT ([HEL_CAMPAIGN_Flight] like '*locker*')

in this case i get a errormessage from qlikview ( Error in set modifier expression )   Any Idea how can i implement it anyway ?

Thank you very much

Regards,

[#2]

When you have just the second part in the condition is it working ?? NOT ([HEL_CAMPAIGN_Flight] like '*locker*')

[#3]

Hi

Try something like that

{ < FIELDVALIDATION={'invalid'} > - < [HEL_CAMPAIGN_Flight]={'*locker*'} > }

[#4]

it doesnt work with 

                            NOT ([HEL_CAMPAIGN_Flight] like '*locker*')

[#5]

hi,

it seems to be better now without an errormessage .  But the calculated value from this formula is wrong !

It must be 99,xxx %. But the modified formula shows 100 %

[#6 · Accepted solution]

You probably can solve that un number sheet (properties) and show X decimals

[#7]

What about

{ < FIELDVALIDATION={'invalid'}, [HEL_CAMPAIGN_Flight]-={'*locker*'} > }

?

[#8]

Thats it

you are right. Instead of 3 points e.g 0,000 , i tried it with 4 points eg. 0,0000.

Thank you very much

[#9]

Thats also works

Thank you too

[#10]

Thank you for your help guys

Best Regards,

Hon