Forum Discussion

rachaelwalker's avatar
rachaelwalker
Icon for Resolver III rankResolver III
5 years ago
Solved

Conditional Lookup on a related table

I wanting to pull data from one column into a new one based on information from another column in another table. Here is an example of my tables. I want a new Utilized Hours column to populate "Actua...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    rachaelwalker I screwed up, get rid of the first ) in your IF statement and should be good to go.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

rachaelwalker If I understand this correctly, you could add columns like the following:

Utilized Hours Column =
  VAR __WorkTypeID = [WorkTypeID]
  VAR __UtilizationFlag = MAXX(FILTER('WorkType',[WorkTypeID]=__WorkTypeID),[UtilizationFlag])
RETURN
  IF(__UtilizationFlag),[ActualHours],0)


Non-Utilized Hours Column =
  VAR __WorkTypeID = [WorkTypeID]
  VAR __UtilizationFlag = MAXX(FILTER('WorkType',[WorkTypeID]=__WorkTypeID),[UtilizationFlag])
RETURN
  IF(__UtilizationFlag),0,[ActualHours])
rachaelwalker's avatar
rachaelwalker
Icon for Resolver III rankResolver III
5 years ago

Greg_Deckler Not sure if I am plugging the correct tables in per your response. I am getting a syntax error.