Hi everyone!
I hope you're all doing well, and thanks for taking the time out of your day to answer my question. I have a code that needs to display - when nothing is selected from my master calendar or list box of last names, but needs to display whichever combination's sum. So right now, if I select a last name it displays a - incorrectly. If I select a date period, it shows the sum of that combination correctly. If it I choose a name and a date period it shows the sum of that combination correctly. If I select nothing, it shows - correctly It just won't show the sum of only a name. I've tried linking it by last name, employee ID, and unique ID with no luck. What am I doing wrong?
=money(if(GetFieldSelections(FiscalMonthYear), sum([Approved Amount]),
//if(IsNull(FiscalMonthYear), 'Select Period',
//if(IsNull(FiscalQuarterYear), 'Select Period',
if(GetFieldSelections(FiscalQuarterYear),sum([Approved Amount]),
// if(IsNull(FiscalMonth), 'Select Period',
if(GetFieldSelections(FiscalMonth), sum([Approved Amount]),
if(GetFieldSelections(FiscalQuarter),sum([Approved Amount]),
//if(IsNull(FiscalQuarter), 'Select Period',
if(IsNull([FiscalYear]), '-',
if(GetFieldSelections([FiscalYear]),sum([Approved Amount]),
if(GetFieldSelections([Last Name]), sum([Approved Amount]),
if(GetFieldSelections([Employee ID]), sum([Approved Amount]),
if(GetFieldSelections(EmployeeID), sum([Approved Amount]),
if(GetFieldSelections([Unique ID]), sum([Approved Amount]))))))))))))
Thanks for all your help!