Forum Discussion

MojoGene's avatar
MojoGene
Post Patron
10 years ago
Solved

LOOKUPVALUE help

I am attempting to determine timekeeper net profit by subtracting the timekeeper's costs from the value of the timekeeper's work.   There is a table, 'TimeTable', that contains columns for [Timekee...
Need Help
  • Sean's avatar
    Sean
    10 years ago

    MojoGene These are the Measures I used ....

     

    YTD Value = TOTALYTD(SUM(TimeTable[Hourly Value]), CalendarTable[Date])

YTD Cost = SUM(Costs[Total Comp])*YEARFRAC(STARTOFYEAR(CalendarTable[Date]), TODAY(),3)

YTD P/L = [YTD Value] - [YTD Cost]

YTD P/L % = DIVIDE([YTD P/L], [YTD Cost], 0)

     

    Here's the sample I created and the result... Hope this helps!

     

MojoGene's avatar
MojoGene
Post Patron
10 years ago

Mike:

 

Thanks for taking a stab at this. Unfortunately, I am still running into a brick wall.

 

The relationships you suggested already existed. 

 

The measure you suggested returned the following error: "Column 'TotalComp' in table 'Costs' cannot be found or may not be used in this expression."

 

Any suggestions on the solution here would be appreciated.

mike_honey's avatar
mike_honey
Memorable Member
10 years ago

You code had a space between TotalComp and ], which I copied.  That mightve been a typo in your OP.  Intellisense should make this easy to resolve at your end.

  • Sean's avatar
    Sean
    Community Champion
    10 years ago

    MojoGene These are the Measures I used ....

     

    YTD Value = TOTALYTD(SUM(TimeTable[Hourly Value]), CalendarTable[Date])

YTD Cost = SUM(Costs[Total Comp])*YEARFRAC(STARTOFYEAR(CalendarTable[Date]), TODAY(),3)

YTD P/L = [YTD Value] - [YTD Cost]

YTD P/L % = DIVIDE([YTD P/L], [YTD Cost], 0)

     

    Here's the sample I created and the result... Hope this helps!

     

    • MojoGene's avatar
      MojoGene
      Post Patron
      10 years ago

      Sean:

       

      Eurika!

       

      Thanks very much.

       

      Gene