Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi below is an example where I want to show percentage of the AR Balance Total for Posting Period. I can only get it to populate for one row of the posting period.
Anyone know how I need to adjust the expressions?
Thank you.
Try this
Sum([AR BALANCE])/ Aggr(NODISTINCT Sum([AR BALANCE]), [posting_date.autoCalendar.YearMonth])
Try this
Sum([AR BALANCE])/ Aggr(NODISTINCT Sum([AR BALANCE]), [posting_date.autoCalendar.YearMonth])
Thank you it worked!
Sum([AR BALANCE])/ Sum(total <[posting_date.autoCalendar.YearMonth]> [AR BALANCE])