Hi All,I'm new to CDS View, Can someone help me with the below logicsIf PERSNUMBER is null in BUT000, get the ADDRNUMBER from BUT020 and pass to ADR6 for email address - this one in join conditionIf email address entry is only one assign that, If mul...

hello All,how to create a parameter in cds view that i must be able to choose either a month, a week or a date using a single date parameter the parameter should show the aggregation of the date as year->month->week->dayis there any way to achieve th...

Hi allusing Data action I have to multiply a measure (percentage) which is stored under unassigned for all dimensions except for Cost center and Date with Salary of all employeeI have around 400 employee.when i multiply it does not produce any result...

Hi all ,I have a requirement where a certain percentage of amount for certain cost center should detected and get stored to a GL called Direct. For example refer below amount 2000 from Cost center 101 where 10% ie. 200 must get allocated to Direct. H...

Hi AllI have to perform an operation where Rate Increase = (Salary * Rate %)/100DATA([d/Measures] = "Rate_Increase_Dollar") = (RESULTLOOKUP([d/Measures] = "Salary") * RESULTLOOKUP([d/Measures] = "Rate_Increase_Percent"))/100 This was working fine til...