Forum Discussion

lpd82's avatar
lpd82
Helper I
4 years ago

calculate static value with filter

Howdy!   How do I formulate "InitialQTY" to yield the result below with  filter Data="Current" applied?  There are other meta data the table such as locations, so I want the "InitialQTY" to summari...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi lpd82 

I still have doubts that when you select data is current , what are the calculation rules of InititalQTY? From the sample you provided, I can't calculate the InitialQTY in result 2. Can you provide a complete sample and describe the calculation logic of your InitialQTY in detail ?

 

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • lpd82's avatar
    lpd82
    Helper I
    4 years ago

    ah; sorry...  I added the data table for clarity.