Create column, applying filters.

[Syndicate_Admin]

Dear! I need to make a column for overtime settlements, identifying when it is appropriate to pay them at %50 or %100.

I have the table 'jornales' with the field [Hs_Extras], I want to generate a colunma for when [Hs_Extras] > 0 only when on Monday, Tuesday, Wednesday, Thursday, Friday and Saturday the value is 50, and when [Hs_Extras] > 0 on Sunday the value is 100.

I tried creating a column from an IF but it didn't work for me. HELP!!

This is the code that applies, Liq_Hs = IF([Hs_Extras] >0 & [Days] = "Sunday", "100", "50")

[Syndicate_Admin]

Dear! Thank you

I leave the example tables:

I need to generate a column = [Liq_Hs_Extras] that when [Hs_Extras] > 0, the value is 50 if the calendar marks Monday Tuesday Wednesday, Thursday or Friday, and when [Hs_Extras] > 0 on Saturdays and Sundays the value is 100. To obetener the following data

Apply a Liq_Hs_Extras = IF([Hs_Extras]>0, "50", "100") but throw all the values at 50.

[Samarth_18 · Accepted solution]

@Syndicate_Admin Create a column like this:-

Liq_Hs_Extras =
IF (
    [HS_extras] > TIME ( 00, 00, 00 )
        && WEEKDAY ( [Fecha], 1 ) = 1
        || WEEKDAY ([Fecha], 1 ) = 7,
    100,
    50
)

Output:-

[Syndicate_Admin]

Thank you for the collaboration. I have served myself and managed to move forward. Thank you.

[Samarth_18]

Hi @Syndicate_Admin ,

What is the error you are getting with below code and could you please help us with sample data in text format with expected output?

Liq_Hs = IF([Hs_Extras] >0 && [Days] = "Sunday", "100", "50")

Thanks,

Samarth