This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question
hcsavage
New Member
Since ‎08-04-2022
‎05-20-2023

My Stats

  • 5 Posts
  • 0 Solutions
  • 0 Likes given
  • 1 Likes received

hcsavage's Bio

Badges hcsavage Earned

View all badges

Recent Activity

How do I return a null value for a negative number in my statement below

10-05-2022
if(is_null(${orders.need_by_date}),diff_days(${orders.created_date},${receipts.receipt_created_date}),diff_days(${orders.need_by_date},${receipts.receipt_created_date}))

Creating if statement to get the time in-between two dates, but if the need by date is NULL then I want to use The create date

09-22-2022
I have this so far. I want to find the number of days between the need by date and the receipt date, but if the need by date is NULL then I want to use the create date. What am I getting wrong? if(${orders.need_by_date}=null,diff_days(${orders.create...

Table Calculation: Custom Expression Help

08-15-2022
I keep getting expression incomplete. I am stuck. concat(if(min(${reporting_date_month}) = 1, "January",if(min(${reporting_date_month}) = 2, "February",if(min(${reporting_date_month}) = 3, "March",if(min(${reporting_date_month}) = 4, "April",if(min($...

Display months as words instead of numbers

08-04-2022
I am currently trying to display Months in a word format instead of a number format for a tile. Above is what it looks like right now and I want it to say JAN-DEC instead.This is what the table calculation is:This is what the entire tile looks like d...
Likes from
View all