UDDC Expressions
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
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
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
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
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
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