@pdexists

Definition

Period exists

Executes commands if a period exists.

Returns

  • True—if the period exists

  • False—if not

Example

For the Sales (v1000) account:

@if(@pdexists(-3),V1000(-3),@na) 

Embedded in a larger formula, this formula ensures that Sales from the 3 previous periods enters the equation. If there are no Sales figures for those periods, it returns N/A.