9 Replies Latest reply: Jan 11, 2018 4:02 AM by Yeo Poh sai RSS

    How to replace L_move <= '01/01/2014' with Year_n<='5' ?

    Yeo Poh sai

      Hi All


      Below expression work fine :-


      =if([C_ONHAND_AMT]>1 and L_move <= '01/01/2014', [C_ONHAND_AMT])


      I neee to replace 01/01/2014 to Year_n <= 5 , In Table 2 i using below expression :-


      =if([C_ONHAND_AMT]>1 and Year_n <= 5, [C_ONHAND_AMT])

      =if([C_ONHAND_AMT]>1 and Year_n <= '5', [C_ONHAND_AMT])

      =if([C_ONHAND_AMT]>1 and Year_n <= "5", [C_ONHAND_AMT])


      it does not work , Hope some one can advise me.


      I expect to make table 1 and 2 same total amount.


      Paul Yeo