Actix 5.5 - Crosstab Query example * Custom Report Creation

[Jesterbean]

Hi Engineers

I'm attempting to create a 'Crosstab Query' calculating 'IMS Registration SR' with the queries listed below. However, as you can see, I've not been successful shown in results.
Could, anyone please help in the creation of this Crosstab Query & subsequent Custom Report for VoLTE analysis

39965

round((state(SIP_RegistrationFailed) / state(SIP_RegistrationOk))*100,1)

sum((state(SIP_RegistrationFailed) / state(SIP_RegistrationOk))*100,1)

round(SIP_RegistrationOk / SIP_RegistrationAttempt)*100

39964

REGDS Jesterbean

[BlackX]

As i try, Actix not support "SUM" function, so you will get NULL value if you use formula expression in PIC-1

So you have to write other formula in excel to calculate KPI what you want.