cancel
Showing results for 
Search instead for 
Did you mean: 

Calculated Member Problem

Former Member
0 Kudos

Hi all!

I have a crosstable with a group made up of a field that contains dates.

The report can have 3 - 4 - 5 columns depending on the selected customer.

I want a calculated member for each date that I give a percentage between two fields that I have identified.

My problem is that if I add a calculated member it makes me just for the column from where I started.

But I want a dynamic column for each client regardless of the date I selected.

is it possible?

I tried using the expert calculated member but as the column of type date I will not allow me to perform calculations on fields that I am.

Thanks

Stefano

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Don't think you can do this in a Crystal genertaed Crosstab.

You will need to build a manual Cross tab

this is where you create formula to define your columns and then add sumaries to a group footer.

Typically a column formula will look like

Col1

If (column1 condition) = true then valuefield else 0

Col2

If (column2 condition) = true then valuefield else 0

This does mean that you have to know the maximum number of columns prior to report design.

You can then perform condtional %age diff on the summaries depending on which contain data.

Ian

Former Member
0 Kudos

....................date1 | mycalculatedmember | date2 | xxxxx

-


row1........... value1 | value1/value1*100 | value2| ....

row2........... value2 | value2/value1*100 | value2| ....

The calculation made for date1 also for date2 automatically without first knowing the number of columns

This is my problem.

any suggestion about it?

Former Member
0 Kudos

Sorry do not understand what you are trying to do.

Please show what you are getting and what you would want to see instead.

How many columns can you have?

Please show what you want to see with max number of columns too.

Ian

Former Member
0 Kudos

Apologize to you and probably you're right, do a little hard to explain.

I have a number of columns that date can vary by client.

for example I have a client who purchased during 2009 and 2010, or customers who have made purchases in both 2008 and 2009 and 2010.

For these cases I want a column to the right of each date column I calculate a 20% increase for each item of all the columns in my reports.

You understand that if I create a dynamic report so if I have 3 years I have 3 columns and 3 calculations, or if I have only 2 should have only 2 columns.

What I can not do is manage this dynamism.

Have been more clear in my explanation?

Former Member
0 Kudos

I think you have to eliminate the dynamism and fix your columns, you can only do this with a manual cross tab,

Each column would be fixed

Typically a column formula will look like

2008

If if year(datefield) = 2008 then valuefield else 0

2009

If if year(datefield) = 2009 then valuefield else 0

You can then perform condtional %age diff on the summaries depending on which contain data.

YOu can have some dynamism by using formula to run for say the last 3 years, so that when you go into 2011 columns automatically switch to 2009, 2010 & 2011.

eg create formula to replace years above, so instead of 2008, use

@year1

year(currentdate)-2

Same formula can be use as you column heading too.

Ian

Former Member
0 Kudos

I will not be bound to the number of columns that I have.

does not solve my problem ... thanks anyway.