Increment a cds field with value leads to circularity???

%3CLINGO-SUB%20id%3D%22lingo-sub-1462077%22%20slang%3D%22en-US%22%3EIncrement%20a%20cds%20field%20with%20value%20leads%20to%20circularity%3F%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1462077%22%20slang%3D%22en-US%22%3E%3CP%3EContext%3B%20making%20a%20canvas%20app%20based%20on%20CDS.%3C%2FP%3E%3CP%3E-%20I%20created%20a%20new%20entity%20with%20a%20field%20named%20StartX%20(type%20integer)%20and%20Distance%20(type%20integer)%3C%2FP%3E%3CP%3E-%20I%20added%20a%20business%20rule%20with%20IF%20logical%20test%3C%2FP%3E%3CP%3E-%20evaluating%20the%20True%20branche%20leads%20to%20the%20formula%3A%20StartX%20%3D%20StartX%20%2B%20Distance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20store%20this%20business%20rule%2C%20I%20receive%20a%20message%20that%20the%20rule%20is%20successfully%20evaluated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20when%20I%20activate%20the%20rule%2C%20I%20receive%20an%20error%20stating%20that%20the%20formula%20contains%20a%20cyclic%20reference.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20used%20the%20same%20formula%20earlier%20in%20another%20version%20of%20the%20App%2C%20based%20on%20a%20SharePoint%20list.%20As%20expected%2C%20the%20same%20formula%20is%20then%20successfully%20evaluated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20my%20question%20is%3A%20why%20doesn't%20a%20business%20rule%20in%20a%20CDS%20allow%20for%20the%20evaluation%20of%20%26nbsp%3Bx%3Dx%2B1%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1462077%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Context; making a canvas app based on CDS.

- I created a new entity with a field named StartX (type integer) and Distance (type integer)

- I added a business rule with IF logical test

- evaluating the True branche leads to the formula: StartX = StartX + Distance

 

When I store this business rule, I receive a message that the rule is successfully evaluated.

 

But when I activate the rule, I receive an error stating that the formula contains a cyclic reference.

 

I used the same formula earlier in another version of the App, based on a SharePoint list. As expected, the same formula is then successfully evaluated.

 

So, my question is: why doesn't a business rule in a CDS allow for the evaluation of  x=x+1? 

0 Replies