Number comparison

[marco_puccetti]

Hello, i need to know how to make a comparison between two numbers.

I've tried with -= to check de difference between two number but it doesn't work, any idea?

Thanks

Marco

[sunny_talwar]

Can you share the data in the two number fields that you are trying to compare?

[sunny_talwar]

and possible the format and decimals for both the fields

[marco_puccetti]

It is simply the comparison between a formula and the 0 value:

If(

Count({<STATO={'ATTIVATA'},RICHIESTA_APERTURA={">=$(=(max(RICHIESTA_APERTURA)-12))<=$(=max(RICHIESTA_APERTURA)-6)"}> }DISTINCT NUMERO_PROPOSTA)

-

Count({<STATO={'ATTIVATA'},RICHIESTA_APERTURA={">=$(=(max(RICHIESTA_APERTURA)-6))<=$(=max(RICHIESTA_APERTURA))"}> }DISTINCT NUMERO_PROPOSTA)

)

<>0

Thanks

Marco

[alexandros17]

Nothing strange but ... could you share the doc.?

[sunny_talwar]

I don't see why this comparison wouldn't work, unless I am missing something small here. May be someone else can spot what might not be working for you.

Best,

Sunny

[marco_puccetti]

Can you tell me the operator to use?

Thanks

Marco

[alexandros17]

Your logic is correct ...