Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
Robby Stamper avatar image
23 ●4 ●4 ●5

Hi, I have an excel request that references the method ZAV(). What is ZAV()? What does it do? Is there a place I can find documentation on that method? =TR("MSFT.O","ZAV(TR.TotalRevenue(Scale=6))","SDate=0 EDate=-199 Period=FQ0 Frq=FQ",B2) Thanks!

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apieikon-for-office
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jirapongse avatar image   Jirapongse

@Robby Stamper

Hi,

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

veerapath.rungruengrayubkul avatar image   veerapath.rungruengrayubkul

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

2 Answers

· Write an Answer
Upvotes
Accepted
zoya faberov avatar image
32.2k ●40 ●11 ●20

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.




formulabuilder.gif (108.0 KiB)
formulabuilderinuse.gif (153.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
chavalit-jintamalit avatar image
18.2k ●21 ●13 ●21

Hi @Robby Stamper

Here is the document for ZAV function.


ahs.png (90.0 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.