1 Reply Latest reply: Aug 3, 2016 11:23 AM by PAUL YEO RSS

    How to make my LY sTOCK display -1,534,101 ?

    PAUL YEO

      Hi All

       

       

      I have below expression from Ruben , it return -1,534,101 when i click on Blue Button is correct :-

       

      Sum({$<year, month, date={'<=$(=AddMonths(Max(date), -12))'}>}TOTAL Aggr(Sum({<year, month, date={'<=$(=AddMonths(Max(date), -12))'},sTOCK = {'sTOCK'}>}[Amount]), YearMonth))

       

       

      But when i not select sTOCK field = sTOCK , it return -1,306,777 which is wrong , How to make it display -1,534,101 ? ( when user click organ color button )

      Reason in QS my app does not allow me activated  field = sTOCK.

       

       

      Paul