Forum Discussion

jaguilarc7's avatar
jaguilarc7
Frequent Visitor
5 years ago

Subtract applying filter

Good afternoon, see if someone can help me with this. Right now I have:

Measure1 = Total KG-A
Measure2 = Total KG-B (filtered that label today)
Those two measures are each assigned to two independence labels in the report.

Needed:
Measure3 = Measure1 - Measure2 *
* but Measure2 has to include the “today” filter.

Example:
Measure1 = 10,000Kg
Measure2 = 8,000 Kg, where once its value is filtered to today = 500Kg
Measure3 = 10,000 - 500 = 9,500Kg

excuse mi english, with your help in the end I will create something decent, hahahaha. 

Thank you.

 

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    jaguilarc7 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.

    • jaguilarc7's avatar
      jaguilarc7
      Frequent Visitor
      5 years ago

      Thank you first for answering and for your interest. I need to be able to do a subtraction where the subtrahend (second digit) is filtered for today. That is, for example:

       

      Annual sales = € 10,000

      Today's sales = € 1,000 (total sales filtered to today)

      MEASURE = € 9,000  (where MEASURE = Annual sales - today's sales)

       

      I need a meassure filtered.

       

      Thx.