3 Replies Latest reply: Jul 3, 2017 4:34 AM by Yeo Poh sai RSS

    How to make 2017 (YTD Exp) display amount = $324 ?

    Yeo Poh sai

      Hi All

       

       

      When i add below script , for reduce the data :-

       

       

      NewFilteredTable:

      NOCONCATENATE

      LOAD *

      RESIDENT sales WHERE

        Year_n < 4;

      DROP TABLES sales;

       

       

       

       

      Below expression display null value :-

       

       

      money(

      Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}Exp/$(Columndim89)/1000)

      , $(vMoneyFormatK))

       

       

       

       

      Hope some one can advise me how to make it work.

       

       

       

       

      Paul Yeo