AnsweredAssumed Answered

Evaluate function to replace unstored calculations

Question asked by mark-it on Sep 28, 2018
Latest reply on Oct 3, 2018 by mark-it

Dear Community

 

I working on replacing unstored calculation in my database using Evaluate function, as I noticed I don't need to keep some calculation unstored all the time.

It works fine if I'm using it with fields in the current table, but I try to connect it with the field from the related table I don't get results. Maybe I miss something (doing wrong) or maybe is not possible to use it this way, can someone confirm that ??

 

Example:

(Field D in Parent Table)

 

Evaluate (

Quote ( Field A*2 & Field B )

; [childTable::Field C] )

 

So if values in field C in the related table will change, Field D should get values from the calculation.

Thanks in advance.

Outcomes