3 Replies Latest reply on Sep 20, 2017 7:53 AM by Tim Dines

# Two parameters in one view applicable for either of the dimension value

Hi, I am stuck with the following problem:

I would like to make use of dynamic parameters for forecasting, the what-if type of analysis. The case is as follows: I monitor periodically the Gender  # calculated as 1. Females # 2. Males # . I would like to make use of 2 parameters in one view, where after populating a number of additional Females using 1st parameter and populating a number of Males using 2nd parameter I would see the changes reflected in the Forecast (in the file: Calculated Measure - CF +HC1 or CF +HC2),

The error I get with the IF formula based on Gender values is as follows:

1. The calculation is incorrect for CF +HC1, with the currect Parameters values selected the outcome should be 15 for Females and for 86 Males  (tab Female Male ratio 1)

2. The formula does not work at all if I aggregate Measure (tab Female Male ratio 2): Error Message I get: Cannot mix aggregate and non-aggregate comparisons or results in IF expressions

Has anybody had a problem like that and could share a solution? That would be so great!

Monika

• ###### 1. Re: Two parameters in one view applicable for either of the dimension value

IF ATTR([Gender])='Female' THEN COUNT([Number of Records])+[P +Female]

ELSEIF ATTR([Gender])= 'Male' THEN COUNT([Number of Records])+[P +Male]END

1 of 1 people found this helpful
• ###### 2. Re: Two parameters in one view applicable for either of the dimension value

Thanks a lot, Tim! So the ATTR reference has been missing... I was very helpful.

I've faced a new challenge though... Have tried to add to this view also Gender ratio based on these Forecasted values for Genders and somehow Quick Table Calculation (Percent of Total) does not work ... Do you maybe know what the reason may be and how to over come it?

• ###### 3. Re: Two parameters in one view applicable for either of the dimension value

Not totally sure I understand what you need, but here is a stab at it.