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!

     

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