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
Making use of Global variables
Calculating Profit/Loss Variance based on What-if Analysis   Description: Finding out the variance of profit or loss by deriving from columns like Act...
Mon, 4 Oct, 2021 at 7:36 PM
Complex UDDC Expressions - Examples
Sr No Input Output Expression Description Example Function Category 1 Gross Sales - Double e.g 70 Target - Double - e.g 100 Performance - e.g 70 % ...
Tue, 2 Aug, 2022 at 3:02 PM