Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])))
Please check my app.
there is no data for 2013 it is why is 0
What did you do?
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.
She added a straight table with a sum by year. No 2013 when TIMEIND= Y.
You have to keep the TIMEIND at Q because I what Quarterly measures. There are separate measures based on Y,Q,M,W TIMEIND.....
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
I will say to use auto number function
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)
no it cannot be duplicate but this ID will work in one app
its enough
=autonumber(Field1 & Field2 & Field3)
Your expression for 2013 is showing Y as your parameter.