Please correct the primary tag! The correct is https://answers.sap.com/tags/01200615320800001016
Second:
You can use ternary operator to check for condition in REC
Search for "Vadim ternary" I have explained it number of times.
First - you have to change question tag - no relation to EPM add-in. Use bpc nw.
Second - the explanation is not 100% clear, add some screenshot with initial values and calculation results. In general it's possible to check value to be positive but not possible to check if it's first positive.
Thanks Vadim. I actually spent several minutes trying to find a BPC related tag. None appeared in the list, so I picked the closest thing I could find. I've included a screenshot that shows what I tried to describe. I want to only save the values in the rightmost column. I've spent the better part of today thinking about this problem and it boils down to one question. Can I use the value (maybe with a boolean comparison) to determine the destination intersection.
I realize the pseudocode below will not work, but I'm hoping it makes my question more clear:
*REC(EXPRESSION=(%VALUE%>0, then save to ACCOUNT_Z otherwise save to ACCOUNT_A))
Add comment