5 Replies Latest reply: Feb 7, 2011 9:45 PM by John Witherspoon RSS

    set analysis newbie

    james wynn

      I have my Master_Dates table in the datamodel with no synthetic joins; it is unaffiliated. I want to sum(ST_Amt) using set analysis and will place a Listbox in the dashboard with the field Fiscal_Week_Year to be used making the selection:

      The code below returns null or zero$s, Itm_Dt is in the main detail table and Week_End is in the Master_Dates table. I am using algebraic expression < = which is probably incorrect. Can you help with a suggestion?

      sum({$< Itm_Dt < = Week_End> ST_Amt})