Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
I have this loading script:
[fact_temp]:
....
if(monthend(date(floor(Timestamp), 'YYYY-MMM'))= monthend(date(Addmonths(MonthEnd(Today()),-1), 'YYYY-MMM')), [Event Reason]) as [Event Reason_new]
Now I need to overwrite [Event Reason] by [Event Reason_new], the statement below is not sufficient. Do yu
[Fact]:
Load *,
if(Leaver=1 and isNull([Voluntary/Involuntary]), [Event Reason_new], [Event Reason_old]) as [Event Reason]
Resident [fact_temp];
Any ideas how to solve?
@TomBond77 Perhaps the null is not really null? You can replace null with Len() if that helps.
if(Leaver=1 and Len([Voluntary/Involuntary])=0, [Event Reason_new], [Event Reason_old]) as [Event Reason]