Hi there, after trying for three days, i'm asking for assistance. Not sure how to post this, so here goes.
I’m building a drill down ledger report in Report Builder and need to return a SUM of the total posting amounts of the matched child codes based off of the parent code.
Basically this is the flow.
Field 1 - return store
Field 2 – return statement code
Field 3 – return posting dollar amount of code in Field 2
Logic for Field 3:
If parent code in field 2 has one or more associated child codes then lookup and sum the posting dollar amount for all the child codes and return that total.
If no child codes exist, then simply ‘return posting dollar amount of code in Field 2‘
What’s the best way to handle this, and would you have any sample code to get me started or through this.