Calculated Attribute for Quarter Activity does not show any value

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