topic Re: function in a set analysis expression in App Development

function in a set analysis expression

chapil — Wed, 01 Sep 2021 08:33:00 GMT

Hy everybody,

I want to use a syntax function in a set analysis expression :

Want to put my dimension upper() to have always maj caracter like this :

sum( {$} < upper([DESCRIPTION]) not equal {"OK"} > isnull([DATE CHECK] )

1st pb -> function upper doesn't work like this

2nd one > how to write <> / != not/ not equal in a set analysis expression ? Like this -= ?

Thanks a lot,

tresB — Wed, 01 Sep 2021 12:24:29 GMT

Try like:

sum( {$ < DESCRIPTION={"=upper([DESCRIPTION]) <> 'OK' "} >} isnull([DATE CHECK] ))

rwunderlich — Wed, 01 Sep 2021 15:18:25 GMT

Double quotes around a value indicate a case-insensitive search.

Not equal is = - .

So:

sum( {$ < DESCRIPTION = -{"OK"} >} isnull([DATE CHECK] ))

uroboros — Wed, 01 Sep 2021 15:28:39 GMT

@rwunderlichJust like Rob indicates.

chapil — Wed, 01 Sep 2021 15:36:47 GMT

Thanks a lot ,

and can I change now the value 'OK' by a flexible value ? for example with an another subject

count({<[PAYMENT DATE] = {"=year([PAYMENT DATE])= '2020' "}>} distinct [DOC NUMBER]) NOT 2020 but max(year([PAYMENT DATE]))

count({<[PAYMENT DATE] = {"=year([PAYMENT DATE])= max(year([PAYMENT DATE])) "}>} distinct [ID]) ?