Good afternoon the community,
I would like to create ratio below in the script
Count({$ < [Code sens]={'B'}>} @id_Axes) / Count({$ <[Code sens]={'S'}>} @id_Axes) as RatioAxes
My script is the following:
TFA_HISTO_INTERET :
LOAD
Capitalize(contrepartie) as Contrepartie,
AutoNumber(Hash128(Date(DATEVALEUR)), 'idDate') as @id_Date,
DATEVALEUR,
// desk as Bureau,
// isin as [Code ISIN],
montant as Montant,
AutoNumber(Hash128(Hour(TIME)), 'idTimr') as @id_Time,
sens as [Code sens],
ApplyMap('MAP_SENS', sens) as libSens,
AutoNumber(Hash128(isin),'idSD') as @id_SECURITY_DES,
AutoNumber(Hash128(isin & contrepartie & sens), 'idAxes') as @id_Axes
FROM
[$(v_Path_Qvd)TFA_AXES_HISTO.qvd]
(qvd)
;
If I use resident my tabs aren't link
Thank you for your help