Skip to Content
0
Jul 24, 2018 at 10:11 AM

How to Run a FOX Planning Function only on the data in your planning buffer

225 Views

Hi Everyone,

I created a simple FOX formula PF that divides a KF by 100. It of course runs on a filter. My initial thought was that the PF will run only on the planning buffer, but it looks like it runs on everything in the filter regardless of the planning buffer. This makes sense but causes an unwanted behavior as it continuously divides all records that match the filter by 100. I tried ticking "Process Changed Data" in Analysis but it didn't change the behavior.Is there a way that I only run this PF on the data from the planning buffer(only the cells I change) ? If not, how would you suggest I display 10 but store 0.1 for example?

Thanks,

Dimitar