Forum Discussion

lancepr's avatar
lancepr
New Member
7 years ago
Solved

Math on a table formula

I have a table that keeps track of items that come in out with a bit field, so I do not have negative number ID  Product InOut qty Date 1  Widget2 True  3     8/1/17 2  Widget2 False 2   8/2/17 3...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi lancepr 

    I have created a new column named New Qty:

    New Qty = IF(T7[InOut] = TRUE(),T7[Qty], -T7[Qty])

    Then another column to SUM:

    Totals =
CALCULATE (
    SUM ( T7[New Qty] ),
    FILTER ( T7, T7[Prod] = EARLIER ( T7[Prod] ) )
)

     

    Good Luck!

    A

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi lancepr 

I have created a new column named New Qty:

New Qty = IF(T7[InOut] = TRUE(),T7[Qty], -T7[Qty])

Then another column to SUM:

Totals =
CALCULATE (
    SUM ( T7[New Qty] ),
    FILTER ( T7, T7[Prod] = EARLIER ( T7[Prod] ) )
)

 

Good Luck!

A

  • lancepr's avatar
    lancepr
    New Member
    7 years ago

    that worked, thanks!