Forum Discussion
Wyatt_Porter
Nov 12, 2021Copper Contributor
Receiving #type! back on calculation
So I am a little stuck and would like to know if anyone can help me with the below Expression: IIf([Asset_Type]="1000",[Beginning Year]," ")+15 Ok, so for the above Expression I am receiving ...
Gustav_Brock
Dec 03, 2021Iron Contributor
You can use:
IIf([Asset_Type]="1000",[Beginning Year],0)+15
If Beginning Year can be Null:
IIf([Asset_Type]="1000",Nz([Beginning Year],0),0)+15