Hi to all,
We have this crossTab that uses his data from a query that comes from the UNION of 2 other queries.
Every calculation seems appropriate but one. The column calculation named [Difference %] isn't displaying the correct numbers as for it displays
an increase for example of 310 % which is really not the case.
Here is the simple calculation inside the data item [Increase %]:
if ( [PreviousYearToDate Sales] = 0 ) then ( 0 )
else ([YearToDate Sales] - [PreviousYearToDate Sales] / [PreviousYearToDate Sales] )
The calculation on the [PreviousYearToDate Sales], [YearToDate Sales] all display correct values.
Also, on the design page the column [Increase %] has the PERCENT data item applied. I tried playing with the SOLVE order of those 3 columns but with no luck.
Am i missing some propertie settings or what ?
Thanks in advance !
doesn't your formula need an extra parantheses like so: (([YearToDate Sales] - [PreviousYearToDate Sales]) / [PreviousYearToDate Sales])
?
also set the solve order property of that column in the crosstab to something like 2
Thank adik but i tried it and no luck. :(
are you getting wrong values or values multiplied by 100?
I'm getting wrong values and they also seem multiplicated by 100 or more as for i receive something like -31,100.00% or -5,100.00% but when i manually calculate them i find out that we should instead get something like -13.96% or -16.44%
What is the 'Aggregate function' property of the data item.
Try Aggregate function=Not applicable, Rollup aggregate function=calculated. solve order =2
Hi,
The values are AUTOMATIC and AUTOMATIC.
But when i changed them to your suggestions i receive the following error message when i do that:
The Report Server is not responding.
Handler trace back: [the_dispatcher] com.cognos.pogo.handlers.performance.PerformanceIndicationHandler
[the_dispatcher] com.cognos.pogo.handlers.logic.ChainHandler
[service_lookup] com.cognos.pogo.handlers.engine.ServiceLookupHandler
[load_balancer] com.cognos.pogo.handlers.logic.ChainHandler
[lb_forwarder] com.cognos.p2plb.clerver.LoadBalanceHandler
[reportservicechain] com.cognos.pogo.handlers.logic.ChainHandler
[warp_with_authenticate] com.cognos.pogo.handlers.logic.ChainHandler
[do_warp] com.cognos.pogo.handlers.logic.ChainHandler
[warpmta] com.cognos.pogo.reportservice.ReportServerHandler
By the way i'm usuing a report page that contains a crossTab which uses a query that comes from the UNION of 2 other queries.
Is the percentage calculated separately in the two underlying queries or does the union query have the calculation expression?