-
ORIG Date format - strip time & convert to DATE column
I need some help in converting the datetime to DATE format and then keep it as a date column rather than a string. For example, we have this ORIG_DT which is a datetime and I use the DateFormat to…
- Answered
-
End of Month custom column (EOMONTH formula)
Is there way to convert dates to End of Month date using formula like EOMONTH. In our system, we do not load data for Sundays or Holidays and I would like to use the EOMONTH formula to convert any…
- Answered
-
Remove "created on" and "slide number" from Present
Is there way to remove the footer from the Present?
- Answered
-
Last month of Quarter - Date Lists & Formulates
I need to create a rollforward which is a Quarterly rollforward (see SNIP below of rough draft). This will past 5 quarters of data. I will be creating formulas for each of the listed items (Beginning…
-
Need help with Dynamic Place Holder - Adddays (business days) to date
Hi I need to create a placeholder text which will show me my base period and comparative period dates. Both of these text placeholders are driven by load date.…
- Answered
-
Measure appearing in a separate row using lag date formulate
I ran into an issue where I have a prior period measure that appears in a separate row when the dimensions change from prior period. In the screenshot attached you can see the loan officer changed…
- Answered
Latest Posts