Slow Calculations

[tmumaw]

Good Morning everyone,

I am having an issue with the amount of time it's taking to do a calculation.  When I select a singles sales office response is fine, however when I select a company code the CPU pegs.....Here is my count statement.

Thanks

count(distinct(if(FISPD = FISPD_CNT and InActive = '1' and FISYR = FISYR_CNT,[Employee Number])))

[annafuksa1]

Please check my app.

there is no data for 2013 it is why is 0

[tmumaw]

What did you do?

[Anonymous]

As a side note, when you are concatenating numbers like that for a key, you probably want to use a delimiter type character to separate the fields within the key.  I usually use a pipe.  For example.

=Field1 & '|' & Field2 & '|' & Field3

This should eliminate the chance of incorrect key duplication.

[Anonymous]

She added a straight table with a sum by year.  No 2013 when TIMEIND= Y.

[tmumaw]

You have to keep the TIMEIND at Q because I what Quarterly measures.  There are separate measures based on Y,Q,M,W TIMEIND.....

[annafuksa1]

I rewrite the expression that couse problems, I did not change the your table to diffeent format  , I add extra chart to see if my calculation is correct

[annafuksa1]

I will say to use auto number function

[Anonymous]

I would think you would still need a character or autonumber could generate duplicate autonumber value?

So you would need something like this:

=autonumber(Field1 & '|' & Field2 & '|' & Field3)

[annafuksa1]

no it cannot be duplicate but this ID will work in one app

its enough

=autonumber(Field1  & Field2 & Field3)

[Anonymous]

Your expression for 2013 is showing Y as your parameter.