Only subtract when there is a minuend / Sólo restar cuando exista minuendo

[jaguilarc7]

Good afternoon, I currently have the measurement: difference M = [unetas M] - [forecast M] But my problem is that if [unetas M] do not exist, the result is always the negative of [forecast M], and I would need that if [unetas M] (minuend) does not exist, the difference measure M is BLANK. Thanks and greetings from a beginner.

/

Buenas tardes, actualmente tengo la medida: diference M = [unetas M] - [forecast M] 

Pero mi problema es que si no existen [unetas M], el resultado siempre es el negativo de [forecast M], y necesitaría que si no existe [unetas M] (minuendo), la medida diferencia M sea BLANK.

Gracias y saludos de un principiante.

[Fowmy · Accepted solution]

@jaguilarc7 

Modify your measure as

M = IF( ISBLANK([unetas M]), BLANK(),[unetas M] - [forecast M])

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn 

[jaguilarc7]

Thx!!!!