Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have data with date, fund and status wise. I need the output based on status column.
the output field calculation is:
The output column has values of previous OFFICIAL status date value. if there is no previous OFFICIAL status day, then it should be min date value.
The data and output as given below.
how to do this? Please help me
Something like the below expression for Output:
If(Above(Status) = 'OFFICIAL' or isnull(Above(Output)), Value,
Above(Output)
)
Hi Anderstrom,
Thank you.
but I need the logic in back script. not in chart expression.
Can you suggest any other idea using script functions?
Anderstrom,
And I need OFFICIAL date value also should be previous date OFFICIAL value.
Temp:
noconcatenate
LOAD
*,
0 as Output
Resident ....;
drop table ....;
Data:
noconcatenate
LOAD
Date,
FundID,
Status,
Value,
If(Previous(Value) = null() or Previous(Status) = 'OFFICIAL', Value,
Previous(Output)) as Output
Resident Temp
order by Date asc;
where the ..... is the table you currently have the data (without Output in it).
This is based on not seeing your data or your model before, so you may need to make some adjustments.