Forum Discussion
Create column, applying filters.
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 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:-
4 Replies
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
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.
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:-
Thank you for the collaboration. I have served myself and managed to move forward. Thank you.
