case when{trandate}={(is within last period)} then...
# suiteanalyticss
Suitestallion
04/08/2021, 9:21 PMcase when{trandate}={(is within last period)} then 0 else 1 How do you write this case when statement
n
Netsuite Tragic
04/08/2021, 9:30 PMCASE WHEN {period} = TO_CHAR(ADD_MONTHS({today},-1),'Mon YYYY') THEN 0 ELSE1 END
2 Views