1 Reply Latest reply on Aug 1, 2018 1:35 AM by Mahfooj Khan

    HOW to gain aggregate value

    cathy su

      Awaiting WIP total: IF first()=0 then window_sum([Awaiting WIP]) END

      PE WIP total: ifnull(WINDOW_SUM([PE WIP3],first(),last()),0)

       

      How to gain aggregate value(80640 and 181440)?

      how to get the delta -189115 result by 80640+181440-451195?