![]() Here, you need to create a formula that will evaluate to a single number for each one of your ranges.ĭECODE(TRUNC (( hours_of_work + 3) / 4), 0, 0.04, If hours_of_work = 1 and 5 then return 0.06 DECODE statement that will return the following:.The date example illustrated above can also be modified as follows:ĭECODE(SIGN(date1-date2), 1, date2, date1) The formula below equals 0, if date1 is greater than date2: Otherwise, the DECODE function should return date1ĭECODE((date1 - date2) - ABS(date1 - date2), 0, date2, date1) DECODE function to compare two dates (date1 and date2), where, if date1 > date2, the DECODE function should return date2.The DECODE function will compare each bank_id value, one by one. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |