Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

QTD numbers are wrong

Hi Experts

 

Can not see the wood for the trees....Assume that you have the following data:

Jan 18     10000

Feb 18     5000

Mar 18    2000

Net Sales data...

 

When the user selects from the slicer Jan and the year 2018 the QTD information. should be just 10000....not the sum of the three months...cannot see the error the the YTD works correctly....

 

 

 

Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous,

     

    Please share your data sample and your QTD formula so that I could test if there is anything wrong with your formula.

     

    Best  Regards,

    Cherrry

4 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous,

     

    More details will be better.

     

    If it is convenient, could you share your formula and your problems?

     

    Best Regards,

    Cherry

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Cherry

       

      When i select QTD from Slicer i get the full QTD numbers for any month i select. ...

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        7 years ago

        Hi Anonymous,

         

        Please share your data sample and your QTD formula so that I could test if there is anything wrong with your formula.

         

        Best  Regards,

        Cherrry