UDDC Expressions

Making use of Case statements (IfCase, When-Then)
1. Derive the total number of days within a selected date range by excluding months (as per the requirement) Description:  Calculate the total number o...
Mon, 7 Jun, 2021 at 3:49 PM
Making use of Date functions
1. Create custom aging values from date dimension w.r.t today’s date Description:  Define custom aging values (0-60 days, 60-90 days, etc.) based on tw...
Mon, 7 Jun, 2021 at 4:11 PM
Making use of Arithmetic functions
1. Convert No. of Seconds to hours format (HH:MM:SS) Description: Convert the time given in seconds to hour format (HH:MM:SS). Example: Time i...
Mon, 7 Jun, 2021 at 4:11 PM
Making use of Cell references
1. Find out the difference in values between two rows Description: Find out the difference in values between two rows (R1 and R2) in the crosstab i.e.;...
Mon, 7 Jun, 2021 at 4:10 PM