Pick Up The Field Figure Base On Period Of Days Criteria

[Fei]

Hi Guys

I need some advice on how to calculate this. I tried using CASE and it doesn't seems like it work.

The Period In Days will increase by day. Depending on the figure in the PERIOD IN DAYS, ie. 16 the <15 will show ZERO. And the <30 will display the stk balance.

 

Case ( PERIOD IN DAYS ≤ 15; STOCK BALANCE;0; PERIOD IN DAYS ≤ 30; STOCK BALANCE;0; )

I did and excel of how should it look like in XLS. 


Thanks in advance
Ken

[comment]

Your example shows 3 columns. That would require 3 calculation fields (or a repeating calculation field with 3 repetitions). And the calculations for <30 and < 60 would require 2 conditions because 12, for example, is not only less than 15,  but also less than 30 and 60.

[comment]

Here's a rather simple way you could look at it:

 

SplitToColumnsR.fmp12

[Fei]

7 minutes ago, comment said:

Here's a rather simple way you could look at it:

Thanks for the enlightenment. Never use Let function before. 

SplitToColumnsR.fmp12 212 kB · 0 downloads