Forum Discussion

Coryanthony's avatar
Coryanthony
Helper III
3 years ago
Solved

Help with calculation please

Hello, I am doing a project on employees, determining overtime meals $ submitted vs overtime meals $ allowed (based on work hours). Then looking to calculate the discrepancy (allowed minus submitted...
Need Help
  • Gokul_G16's avatar
    Gokul_G16
    3 years ago

    Hi thx ,

    I will do one thing, Can please take 
    Distinct employee or just summarize the separate table 
    for unique employee code .
    post that fix over all 8 hrs per day wise count.
     else. you can concatenate the EMP & Date, by the way you can have it unquie count. $25.

    Dax. 
    Test = 
    VAR _V1 = CONCATENATE ( EMP , DATE)
    RETURN 
    CALCULATE ( SUM ( #hrs), _v1=_v1).

    Can you try this way,

    Thanks.
    Gokul

      

Gokul_G16's avatar
Gokul_G16
Resolver I
3 years ago

Hi Coryanthony ,

can you please brefly your requirement !
Then you will get update.
You wnat calculate sum or avergae. else?.


regards,
Gokul

thx's avatar
thx
Frequent Visitor
3 years ago

hi Gokul,

I want to calculate the sum of $ allowed (per employee). The allowed $ is based on hours worked in that given day.

 

Jane smith time sheet:

Date    | Units(hours) | chargecode

1/1/23 | 5hours         |  40001010

1/1/23 | 3hours         |  40274990

1/1/23 | 3hours         |  72849999

 

My current issue is, since the employee worked over 10 hours on 1/1/23, employee would be allowed $25 for that day. But since there are 3 rows related to 1/1/23, the allowed is showing $75 (multiplying x #rows).

 

thank you for your help and assistance. 

i think that's what the user is saying. As I am having similar issue. 

 

  • Gokul_G16's avatar
    Gokul_G16
    Resolver I
    3 years ago

    Hi thx ,

    I will do one thing, Can please take 
    Distinct employee or just summarize the separate table 
    for unique employee code .
    post that fix over all 8 hrs per day wise count.
     else. you can concatenate the EMP & Date, by the way you can have it unquie count. $25.

    Dax. 
    Test = 
    VAR _V1 = CONCATENATE ( EMP , DATE)
    RETURN 
    CALCULATE ( SUM ( #hrs), _v1=_v1).

    Can you try this way,

    Thanks.
    Gokul