Sustraction of two key figures

[Former Member]

Hi all!!

I have a question about formula in a query..

I have two key figures and when the sustraction of two key figures is cero or negative I want to show the value cero

For example:

Key figure A- Key Figure B = -2 show me in the query= 0

Thanks for the help.

Greetings

Mónica

thanks again

[Former Member · Accepted solution]

Monica,

Try this...

((Key figure A- Key Figure B) > 0)*(Key figure A- Key Figure B)

Hope this helps...

[former_member188975]

Hi Monica,

You can try something like: ((A-B)>=0) * 1

Hope this helps...