How the sequence of expression should be in a single ruleset in RPAS
We have a query in this below expression
A = if(UnelapsedB, B*C, ignore)
B = A/C
B - has No Database,No load rule, No commit rule (recalc - Default agg)
A - has Database,load rule,commit rule (total - Default agg)
C - has Database,load rule,commit rule (total - Default agg)
Data loaded in Back-End:
A - 10
B - 2
C - 5
In the Front-End we are getting the below values:
Elapsed period
A - 10
B - 2
C - 5
Unelapsed Period
A - 0
B - 0
C - 5
For elapsed period, As "B" does not have the database when I re-open the workbook "A" will be Zero.