10 Replies Latest reply on Nov 18, 2018 10:26 PM by ShivaRam Chennapragada

    Help with calculation

    Alyssa Ashton

      I'm having trouble with the syntax for a calculated field...I have a table with Amount and a boolean field called Is Current.  I want to create a calculated field for the current amount, something like if Is Current = 1 then Amount End AS Current_Amount.  I'm having trouble with the syntax for a CASE or IF and can't get anything to work...

       

      THanks!