Hi, I have an excel request that references the method ZAV(). What is ZAV()? What does it do? ...

Hello @Robby Stamper,

The Zero Available function (ZAV) provides a method to replace nulls with a numeric zero.

In Excel, so this function does not apply to Eikon Data API Python.

I am updating my answer to include the recommended approach, how to look this information up in Eikon Excel documentation.

Select FormulaBuilder tool from Eikon Excel:

In FormulaBuilder, select

1. Instruments: MSFT.O
2. Data Items: TR.TotalRevenue
3. Next, on the right hand side, in Parameters & Quick Functions section, check "Treat As Zero If Not Available"
4. Lastly, if you "Open in Expression Editor"

Should see expression

ZAV(TR.TotalRevenue(Period=FY0,Scale=6))

ZAV() being the result of "Treat As Zero If Not Available" quick function in Expression Builder.