Skip to content
  • There are no suggestions because the search field is empty.

How to Change Null/Empty Values to "0" in Analyst Studio

Once you have created a new visualization, add a new field.

2026-02-04_10-10-56

Select "Calculated Field".

2026-02-04_10-12-05-1

Give the field a new name.

For this example, we will use Applied Phosphorus and change any Null/Empty values into "0"s.

2026-02-04_10-14-42

 

Type in this formula with the desired attribute (Remember, for this example, we're using "Total Phosphorus Nutrient Applied".) and click the "Create Field" button.

2026-02-04_10-18-31

IF(LEN([Total Phosphorus Nutrient Applied])>0,[Total Phosphorus Nutrient Applied],"0")

 

This new Field can be added and used in your chart.

2026-02-04_13-14-45

 

If you have any questions or need assistance, contact your advisor support representative.