0

I set up a system with multiple accounts. Each is a share of a total fund balance which is used to calculate shares of total income. Year Ends April is the individual balance table year and the dashboard year is Fiscal Year. This is tracked by year and I set up a dashboard table to enter total dividends that then get distributed by share. If I enter multiple year info on the dashboard the dividends don't show up. Here's the code that works perfectly when only one year is entered. Any ideas

let y := 'Year Ends April';
let i := (select Dashboard where 'Fiscal Year' = y).TempBal;
let TempNum := number(i);
let j := ('Beginning Balance-Temp' + 'Beginning Balance Perm') / TempNum;
let k := (select Dashboard).Dividends;
let TempDiv := number(k);
j * TempDiv

Reply

null
Login to reply

Content aside

  • 4 yrs agoLast active
  • 687Views