6 Replies Latest reply: Mar 11, 2013 6:43 AM by Manu

# How to calculate percentage with two different columns on two differentdate

Hi

I have created a union all pivot report with two columns where these two columns are based on two different date fields. when i am calculating percentage of these two columns , getting only wrong percentage, since it is calculting based on only one column date field.
Can any one suggest

Thanks
• ###### 1. Re: How to calculate percentage with two different columns on two differentdate
hi
use union of tables in answers levelin that also u can give percentage in the report level

pls mark as coreect if helpful

thanks
• ###### 2. Re: How to calculate percentage with two different columns on two differentdate
Hi,

we generally union/combine results, but where i can give union of tables options. Can you please provide information more clearly

Thanks
• ###### 3. Re: How to calculate percentage with two different columns on two differentdate
You approach should be some thing like below link

Time being ignore the joins in that link, try to do your calculations on outer query, that will work.

Let me know updates. if helps mark
• ###### 4. Re: How to calculate percentage with two different columns on two differentdate
Hi

I have created a union all pivot report with two columns where these two columns are based on two different date fields from two different tables not from single table. when i am calculating percentage of these two columns with two date columns from two tables, getting only wrong percentage, since it is calculting based on only one column date field.
Can any one suggest

Thanks
• ###### 5. Re: How to calculate percentage with two different columns on two differentdate
In this case what I would do is; I write sql query manually, I verify the results and compare the manual sql query with BI generated physical query based on that I would do required logical query changes on BI.

We can give suggestions but not validate your issue since we dont have access and own it
• ###### 6. Re: How to calculate percentage with two different columns on two differentdate
HI

i created one criteria on date1 dimension table having join on date1_date column , with one coumn from fact table(measure1) and created another criteria on date2 dimension table having join on date2_date column ,with one coumn from fact table(measure2). using union all report i got expected values for measure1 and measure2. Now i am trying to calculate measure1/measure2. Since these measures are calculated on two different date dimensions i am getting worng values.