Property Calculator Basic Examples

Overview

Each example includes the scenario, the expression, a step-by-step explanation, and the expected result. All examples use Calculate Expression mode unless noted otherwise.

1. Simple Arithmetic — Calculate Total Price

Scenario: An invoice line has Quantity and Unit Price properties. Calculate the Line Total.

%PROPERTY_{PD.Quantity}% * %PROPERTY_{PD.UnitPrice}%

Explanation: Both placeholders are resolved as numbers and multiplied.

2. Text Assembly — Build Document Title

Scenario: Automatically generate a document title from project code and document type.

%PROPERTY_{PD.ProjectCode}% - %PROPERTY_{PD.DocumentType}% - %PROPERTY_{PD.Revision}%

Explanation: With “Evaluate as Expression” OFF, placeholders are simply replaced with their text values. No NCalc evaluation occurs.

3. Conditional Text — Priority Label

Scenario: Display a human-readable priority label based on a numeric score.

iif(%PROPERTY_{PD.Score}% >= 80, 'High Priority',
  iif(%PROPERTY_{PD.Score}% >= 50, 'Medium Priority', 'Low Priority'))

Explanation: Nested iif() functions create a tiered classification. The outer iif checks ≥80 first, then falls through to the inner iif for ≥50.

4. Date Calculation — Due Date

Scenario: Set the payment due date to 30 days after the invoice date.

dateAdd(%PROPERTY_{PD.InvoiceDate}%, 30, 'days')

5. Null-Safe Display — Contact Info

Scenario: Show the primary email if available, otherwise fall back to secondary email, then to “No email on file”.

coalesce(%PROPERTY_{PD.PrimaryEmail}%, %PROPERTY_{PD.SecondaryEmail}%, 'No email on file')

6. Lookup Name Check — Status-Based Flag

Scenario: Set a boolean flag indicating whether a contract is active.

lookupName(%PROPERTY_{PD.ContractStatus}%) == 'Active'