Forum Discussion

MojoGene's avatar
MojoGene
Icon for Post Patron rankPost 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!

     

mike_honey's avatar
mike_honey
Icon for Memorable Member rankMemorable 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
Icon for Community Champion rankCommunity 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
    Icon for Post Patron rankPost Patron
    10 years ago

    Sean:

     

    Eurika!

     

    Thanks very much.

     

    Gene