...DP.Data("LHAG120cI3.EX",22) instead of the displayed "NULL" ?
Resolver not registered: react.asset.discussionTagsAsset
Hi @marcel.thaele ,
In the formula builder's parameters tab, there's an option "Treat As Zero If Not Available" which after this is applied, the ZAV() will be applied in the Excel formula
The formula is
=@RDP.Data("LHAG120cI3.EX","TR.CLOSEPRICE;ZAV(TR.VOLUMEOPENINTERESTRATIO)","CH=Fd RH=IN",B2)
For example, below is the different between ZAV applied and not applied
I have also found the following solution : =RDP.Data(LHAG120cI3.EX;22;"NULL=0")
Many thanx Marcel
Permission Problem You need the session.valid permission to do that.