Scenario: User has created additional fields in Purchase order.

review PO, user wants to display result as below since Allocation 4 is updated





If set formula like this,
Expression [Allocation_2] + [Allocation_4]

System will not display result  

Because user is just updated Allocation 4 but without Allocation 2

So how should we set the expression in this scenario?





Step 1: Add Calculated Field


Step 2: Point to the field --> Edit Calculated Fields





 Step 3: Edit Name

Step 4: Update Expression as below
 Iif(IsNullOrEmpty([Allocation_1]),0 ,[Allocation_1] ) + Iif(IsNullOrEmpty([Allocation_2]),0 ,[Allocation_2] )