Sum Error in expression nested aggregation not allowed

[publication1]

I have this in my set analysis:-

Count of Order_num = 635
Count of Order_num where PSTN = Yes = 257

Its doing the first part correct and showing 635 - 257 = 378
= Count(Order_Num) - Count { <,PSTN_PROVIDE={'Yes'}> }ORDER_NUM)

however when I say * 1084 like so,
= Count(Order_Num) - Count { <,PSTN_PROVIDE={'Yes'}> }ORDER_NUM) * 1084

the answer should be 409,752 however its showing as -277,953 which is incorrect

[MayilVahanan]

Hi @publication1 

Try like below

=(Count(Order_Num) - Count ({ <PSTN_PROVIDE={'Yes'}> }ORDER_NUM)) * 1084

[publication1]

I have tried however its still giving me a negative number.

=(Count ({ <PRODUCT_FAMILY={'EAD'},BANDWIDTH_MBITS={'0','10','100','1000'}> }ORDER_NUM))

/100

*3.1 - Count ({ <PRODUCT_FAMILY={'EAD'},PSTN_PROVIDE={'Yes'},A_END_MAIN_ROUTER_RQRD={'Y'},BANDWIDTH_MBITS={'0','10','100','1000'}> }ORDER_NUM) * 1084

[publication1]

Can anyone give me a pointer on how to correctly set the below up. I have set analysis however its giving me a negative number and im sure its because it has to be in a different format

/* Expected orders */
=(Count ({ <PRODUCT_FAMILY={'EAD'},BANDWIDTH_MBITS={'0','10','100','1000'}> }ORDER_NUM)) /100 * 3.1

-
/* Actual orders */
Count ({ <PRODUCT_FAMILY={'EAD'},PSTN_PROVIDE={'Yes'},A_END_MAIN_ROUTER_RQRD={'Y'},BANDWIDTH_MBITS={'0','10','100','1000'}> }ORDER_NUM)

* 1084

the maths should be

635 - 257 = 378
Expected orders - Actual orders = Answer then Im needing Answer * 1084 to give me 409,752

Its currently giving me Minus -277,953

[MayilVahanan]

Hi,

Can you share the sample app

[PradeepK]

I suggest you to breakdown your problem into smaller parts and test it first.. i.e. Test Expected and Actual orders expressions separately. 

Keep note of operator precedence -> () , * ,  / , + ,  - 

Expression For Reference Only :

(
	( 
    	Count ({ <PRODUCT_FAMILY={'EAD'},BANDWIDTH_MBITS={'0','10','100','1000'}> }ORDER_NUM) / 100 
    ) * 3.1
)

-

(
	Count ({ <PRODUCT_FAMILY={'EAD'},PSTN_PROVIDE={'Yes'},A_END_MAIN_ROUTER_RQRD={'Y'},BANDWIDTH_MBITS={'0','10','100','1000'}> }ORDER_NUM) * 1084
)

Hope this helps.

[publication1]

Finally got it - Was keen to get it sorted within the set analysis

=(Count ({ <PRODUCT_FAMILY={'EAD'},BANDWIDTH_MBITS={'0','10','100','1000'}> }ORDER_NUM)

/ 100 * 3.1 -

Count ({ <PRODUCT_FAMILY={'EAD'},PSTN_PROVIDE={'Yes'},A_END_MAIN_ROUTER_RQRD={'Y'},BANDWIDTH_MBITS={'0','10','100','1000'}> }ORDER_NUM))