5 Replies Latest reply on Jan 24, 2018 12:25 PM by arvindgarg

# Hi Everyone

I have got a complex case, let us assume 3 columns

Fact A : Percentage of an average

Fact B : Sum in \$ amounts.

Dimension : %,\$

My case : I have to merge these 2 facts into 1 column based on the dimension.

Condition : If dimension is \$ then the it should be Fact A% else Fact B\$.s

Dimension    Column

%                  20%

\$                      100%

%                    30%

Ideas are welcomed.

• ###### 1. Re: Hi Everyone

I believe a simple if else statement should work.

If dimension = \$ then fact with dollar

else if dimension = % then fact with percentage.

End

• ###### 2. Re: Hi Everyone

Hi Arvind,

I tried to write the same logic but there is a logic behind sum and avegare which are getting aggregated and creating differences.

I can send you a sample workbook if you want to.

• ###### 3. Re: Hi Everyone

yes sample workbook will be great.

• ###### 4. Re: Hi Everyone

Can I send the sample onto your gmail id?

• ###### 5. Re: Hi Everyone

yes sure