calcular campos sin mostrar el valor o resultado 0

New Here ,
May 16, 2022 May 16, 2022

Copy link to clipboard

Copied

Hola a tod@s!

He confecionado una factura típica con campos calculados, como por ejemplo, número de unidades de un producto por el precio unitario. Esto lo he hecho en la casilla "Anotación de campo simplicada": Text4*Text6.

Esto ha funcionado bien, pero no tengo ni idea de cómo hacer para no mostrar el valor 0,00 € que se muestra de manera predeterminada cuando no se pone ningún producto * valor unitario.

Entiendo que se debe poner alguna condición del tipo que se utiliza en excel: SI(A1*A2=0, "", A1*A2).

No tengo ni idea de javscript que es lo que requiere poner en cálculo.

Muchas gracias por adelantado!

TOPICS
Create PDFs

Views

73

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , May 16, 2022 May 16, 2022

Place this as a Custom Format script in each calculated field:

if (event.value == 0) {event.value = ""};

Likes

Translate

Translate
Community Expert ,
May 16, 2022 May 16, 2022

Copy link to clipboard

Copied

Hi,

 

Yes you'll need to employ JavaScript instead of using Simplified Field Notation method.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
May 16, 2022 May 16, 2022

Copy link to clipboard

Copied

Place this as a Custom Format script in each calculated field:

if (event.value == 0) {event.value = ""};

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 17, 2022 May 17, 2022

Copy link to clipboard

Copied

LATEST

You have helped me a lot. Thank you very much.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines