Forum Discussion

Stymied9's avatar
Stymied9
Frequent Visitor
9 years ago
Solved

Subtracting calculated columns from different data sets

I have 5 different data sets uploaded.  In each of those 5 data sets, I have a calculated column (CPK) (example: Column X / Column Y = Z).  I then have those 5 calculated columns entered into a Table...
Need Help
  • Stymied9's avatar
    Stymied9
    9 years ago

    I was able to get it sorted out.  I believe it was the CPK's in the data sets that were changed to an average which was messing everything up.  I needed to nto use those, but create a measure for each data set, then create anew measure FY16 - FY15, which gave me the solution i needed.

  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Stymied9,

    Glad to hear the issue is solved, you can accept helpful replies as solution, that way, other community members will easily find the solution when they get same issue.

    Thanks,
    Lydia Zhang

Stymied9's avatar
Stymied9
Frequent Visitor
9 years ago

I was able to get it sorted out.  I believe it was the CPK's in the data sets that were changed to an average which was messing everything up.  I needed to nto use those, but create a measure for each data set, then create anew measure FY16 - FY15, which gave me the solution i needed.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Stymied9,

Glad to hear the issue is solved, you can accept helpful replies as solution, that way, other community members will easily find the solution when they get same issue.

Thanks,
Lydia Zhang