Share
Report
2We have rollup fields that calculate the total amount for invoices for each quarter in the prior year and for each quarter in the current year. We are trying to make the dates that are used in the filters be dynamically calculated so that users don't have to go in and update them every year. However, the rollup field on the account is giving an invalid definition error for the calculated dates.
Below is the formula for PY_Q1_Start, the formulas for the other dates are essentially the same. Each field is giving the same error.
DateAdd(
DateAdd(
DateAdd(
UTCToday(),
-1,
TimeUnit.Years),
((Month(UTCToday())-1)*-1),
TimeUnit.Months),
((Day(UTCToday())-1)*-1),
TimeUnit.Days)
All responses (
Answers (
