Last Non Zero
Had a Partner ask if there is anything that does a "last non zero value" like our first non zero. Discussed ranking, but apparently that wouldn't work.
Tagged:
1
Comments
-
Status changed to: New0
-
The modeler can achieve the same effect with a simple formula. Imagine a numeric line item called Input. The last non-zero value (across a timescale, assuming that's the use case) can be computed for a line item Output using Output = IF Input <> 0 THEN Input ELSE PREVIOUS(Output)
0
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!