Forum Discussion

wverheijen's avatar
wverheijen
Frequent Visitor
7 years ago
Solved

Fetch value from column by category

Hi! I have a worktime-table which specifies per employee how many hours they work on each day according to their countract: employee hoursonmonday hoursontuesday hoursonwednesday hoursonthurs...
Need Help
  • wverheijen's avatar
    wverheijen
    7 years ago

    Fixed it!

     

    The problem was that the relationship between timesheetentry and employees in my original table was set to "double" while it's supposed to be "single". This was all.

     

    v-piga-msft big thanks for your help and effort!

wverheijen's avatar
wverheijen
Frequent Visitor
7 years ago

Hi cherry,

 

I was working on duplicating a dummy report for you in the same structure as my original table. When replicating my table, i suddenly got the result I'm looking for.

 

So if I recreate my table to a dummy, it works nicely, but my original report in thes same structure doesn't. I've tracked a single user ID and it should appear exactly the same.

 

Any thoughts?

 

You can look into the report here: https://1drv.ms/u/s!Aq8v0AAEkXxvgapoGfLv0j6q61FncA

wverheijen's avatar
wverheijen
Frequent Visitor
7 years ago

Fixed it!

 

The problem was that the relationship between timesheetentry and employees in my original table was set to "double" while it's supposed to be "single". This was all.

 

v-piga-msft big thanks for your help and effort!

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi wverheijen,

     

    You're welcome! It's glad that you have solved your problem.:smileyvery-happy:

     

    Best Regards,

    Cherry