RATIO

sagaraperera — Fri, 15 Nov 2024 22:10:21 GMT

DEAR ALL

I want to get the relevant RATIO as mentioned below. The required EXPRESSION is given below.

REG	MONTH	MO	2022	RATIO
F	05	MOTOR	21,572,659	A/T	A
F	05	NON_MOTOR	89,835,261	B/T	B
F	05	Total	111,407,919	T/T	T
M	05	MOTOR	75,337,371	A/T	A
M	05	NON_MOTOR	12,378,710	B/T	B
M	05	Total	87,716,081	T/T	T

			EXPRESSION= Sum ( {$<FLAG= {'Y'} >}[GROSSTOT])

Re: RATIO

hic — Thu, 02 Jun 2022 13:04:06 GMT

It seems as if you want to get the relative numbers, i.e. divide by the total for the group. If so, you should try

Sum ( {$<FLAG= {'Y'} >}[GROSSTOT])
/
Sum ( {$<FLAG= {'Y'} >}total <REG,MONTH> [GROSSTOT])