We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Calculated Attribute for Quarter Activity does not show any value

Accepted answer
20
Views
4
Comments
edited Aug 26, 2020 5:44AM in Account Reconciliation 4 comments

Summary

Calculated Attribute for Quarter Activity does not show any value

Content

All - I am trying to bring activity between quarters with calculated attribute using 'scripted' condition but I see no value coming up. Am I missing something here?

Here is my condition and the attribute is calculated with Number as type.

IF_THEN_ELSE( {Preparer Frequency} = 'Quarterly',
 PRIOR( {Source System Balance(Functional)}, 3, 'USD', 'REC'), 
 PRIOR( {Source System Balance(Functional)}, 1, 'USD', 'REC'))
 - TRANSLATE( {Source System Balance(Functional)}, 'USD', 'REC')

 

-Hari

Version

20.08

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!