Hi Cognos Experts,
I have a requirement where I have to create a column for creating the percentage dynamically.
I have to create the comparison percentage.
In the cross tab report I have my dimension as Supplier Name and I am displaying Full Rate for each supplier in the columns.
Supplier 1 Supplier 2 Supplier 3
Full Rate 1 Full Rate 2 | Comparison%(Full Rate1/Full Rate2) Full Rate 3 | Comparison%(Full Rate2/Full Rate3)
And So on.
So can I get this requirement done in Cognos Cross Tab Report. Any help would be really appreciated.
Is this a relational or dimensional source? If it's dimensional then it would be a simple matter of doing:
[Full Rate] / tuple([Full Rate],prevMember(currentMember(SupplierHierarchy)))
Relational sources are a little more difficult. Try doing something like
PrevFullRate:
moving-total([Full Rate],2) - [Full Rate]
That should give you the value for the previous column. Then do [Full Rate] / [PrevFullRate]
If you have something in your rows, then the moving total should look like this:
moving-total([Full Rate],2 for [Row Data item]) - [Full Rate]
Its a relational model
Is moving-total([Full Rate],2) - [Full Rate] working?
Hi Paul,
Unfortunately the calculation is not giving me the correct value of the percentage