Multiply two fields, if no value zero

HCL Domino Domino Forum
1

I have a Computed amount and I want to multiply it by the Qty field. If there is no value in the field I need the default of zero, otherwise I can’t total if there is a blank field.

Computed field from lookup - Adj$_1 multiplied by Qty field - AdjQty_1

If there is no value, field must equal zero.

2

Subject: Not Sure what you have tried

I would probably use something like:

Result: = Adj$_1 * AdjQty_1;

@IF(@iserror(Result);0;Result)

3

Subject: Thank you it worked