1 Reply Latest reply on Dec 29, 2016 11:51 AM by lenaic.ridinger

# Calculation on the subset of the Data

The Calculation Average on a MAIN_ATTRIBUTE which has two values like Basic and Pro

{ FIXED [AttributeName1],[MAIN_ATTRIBUTE],[AttributeName3],[AttributeName4]:AVG([AnotherAttribute])}

When i use the above Calculation i will be having 0.55 and 0.85 for Basic and Pro respectivly

But what i m looking for is for the Pro it should be like 0.55*0.85

which in case the formula can be like this,which is syntactically wrong

if MAIN_ATTRIBUTE = 'Basic'
THEN
{ FIXED [AttributeName1],[MAIN_ATTRIBUTE],[AttributeName3],[AttributeName4]:AVG([AnotherAttribute])}
ELSE MAIN_ATTRIBUTE = 'Pro'
{ FIXED [AttributeName1],[MAIN_ATTRIBUTE] == 'Basic',[AttributeName3],[AttributeName4]:AVG([AnotherAttribute])} *
{ FIXED [AttributeName1],[MAIN_ATTRIBUTE] == 'Pro',[AttributeName3],[AttributeName4]:AVG([AnotherAttribute])}
END

in the else part it should be it should be the product as shown above,How can this be acheived, BAsically how to calculate on the subset of the main data.

• ###### 1. Re: Calculation on the subset of the Data

Hello Ronaldo m,

Could you please try the following?

IF MAIN_ATTRIBUTE = 'Basic'

THEN {FIXED [AttributeName1],[MAIN_ATTRIBUTE],[AttributeName3],[AttributeName4]:AVG([AnotherAttribute])}

ELSE MAIN_ATTRIBUTE = 'Pro'

SUM([MAIN_ATTRIBUTE])/COUNT([AttributeName1],[MAIN_ATTRIBUTE],[AttributeName3],[AttributeName4])

END

If this is not what you were looking for, could you please post a workbook so we can have a keener look at your question?