英文:
Spotfire date difference using over function if no previous in first rank
问题
我找到了解决一半问题的方法，参考此链接：https://stackoverflow.com/questions/31344663/spotfire-date-difference-using-over-function
然而，现在我需要填充 Rank 1，因为它没有先前的日期？
假设我想要与一个帖子中呈现的相同结果，但是对于那些没有先前日期可以计算的情况（现在用 Rank 1 空着），我想要添加不同的计算，例如列 A - 列 B。我该如何做？
英文:
I found a solution to half of my problem following this link : https://stackoverflow.com/questions/31344663/spotfire-date-difference-using-over-function
However, now I need to fill in the Rank 1 since it doesn't have a previous date?
Let's say I want the same result as in a post presented, however for the ones that do not have previous date to calculate (now empty with Rank 1), I want to add different calculation eg. column A- column B.
How do I do that?
答案1
得分: 1
你尝试过在Spotfire中使用SN()函数吗？因此，SN(A, B)会在A不为空时返回A，否则返回B。
英文:
Have you tried the SN() function in Spotfire? so SN(A,B) gives you A if not null, otherwise it gives you B
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论