Forum Discussion
Calculate function within calculated columns.
Hi All,
not sure if anyone has come across this before but I'm slowly questioning my sanity over the following.
I have recently completed work for a client which implements dynamic ranking across selected measures.
this all works well but I've found the performance experience quite poor using measures alone
so, to get around this I have created a calculated table which pre calculates all of the totals for each of my locations, which I can then use to perform the ranking.
this all sounds straight forward so far.
the issue i have is that some of the calculated columns are not calculating correctly, mainly those ones that are calculating from tables that have over 1,000,000 rows.
any thoughts?
Dog
4 Replies
Tough to say without the data, rounding?
Hi,
not rounding nope just whacky figures like 1.09993353544e-10
which display as zero.
Ive moved on slightly since then and it looks like it may have been an issues with the number of records.
I've replaced my original calculated table by summarizing at a higher level and thus reducing hte number of records.
not ideal as I've had to implement several more layers of filters but it's certaintlt getting closer.
have you ever heard of using calculate in a calculated column on a table with over 1 mil records causing a rather large zero value with many decimals.
Nope, that's a new one. Can you at least post your CALCULATE formula? If I can dig up a table with a million rows or generate one I'd be interested to test it out.
