How many ways finding missing values

[Anonymous]

hi all

[petter]

42

[Anonymous]

examples

[balabhaskarqlik]

Like below, there are many ways to identify missing values and fill those values.

Pivot table - Presentation, you can select the sign to show when is Null.

like if(sum(sales) = '-','!','V')

like if(isnull(field1),Peek(field1),field1) as field2 resident TransactionTable

Using Master calendar

Using Previous(), Peek()

Using variables.

AutoNumber()