7 Replies Latest reply on Mar 15, 2017 12:00 PM by Harnish Patel

# Distinguish a measure between values of a dimension

Hi everyone,

I am having trouble creating a calculated field to distinguish between two values of a dimension.

I want one field to show all of the values that are Type = "Budget" and the other to show all of the values that are Type = "Actual"

So I can create a boolean: Budget > Actual, but all values are returning NULL.

• ###### 1. Re: Distinguish a measure between values of a dimension

They seem to be working fine to me?

You need to remove the 'Type' field from the sheet in order for it work properly.

• ###### 2. Re: Distinguish a measure between values of a dimension

Yes that works, but when I want to use those fields to do another function, the logic falls apart somewhere.

Re: Caculated field "Act vs Bud"

• ###### 3. Re: Distinguish a measure between values of a dimension

Hey Harnish,

Is this what you want to accomplish?

You can color by Actual - Budget < 0 to calculate whether it is over budget or not. This is a table calc and needs to be computed along the Table (across).

Please let me know if you have any questions or clarify what you're hoping to achieve.

Hope this helps!

Lisa Li

1 of 1 people found this helpful
• ###### 4. Re: Distinguish a measure between values of a dimension

YES! Exactly.

Is there a way to do this without it being a table calc? Like if I want to reference calculated fields instead?

• ###### 5. Re: Distinguish a measure between values of a dimension

Fixed Actual Value:

{fixed [Month]: sum([Actual Value])}

Fixed Budget Value:

{fixed [Month]: sum([Budget Value])}

Note it returns the Actual Value and Budget Value for a specific month.

-Lisa

1 of 1 people found this helpful
• ###### 6. Re: Distinguish a measure between values of a dimension

This was wonderful. Thank you all so much for your help!

• ###### 7. Re: Distinguish a measure between values of a dimension

Naturally now I'm having another problem.

Including an upward arrow or downward arrow based on the result of the boolean.

I get arrows on both columns (Actual and Budget) or none at all; I can't seem to insert a new column to the right of the data that says up or down.

I want to eventually do this for more data points than what I have here - the format woule be as follows: Actual Value, Budget Value, Directional Shape; Actual Value 2, Budget Value 2, Directional Shape 2...