Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Work in Dynamic calculations

Hi,

 

I've attached a sample data and my requirement is to get the resultant dataset (On Right in attachment) after multiplying with Selected Multiplication value in the data. The selection value can be from  1 to 10 by user.

 

https://drive.google.com/file/d/1oN9VYGRbmWeUrxhiWtJXjfTKB6dpI6AW/view?usp=sharing

 

REgards.

Tips and Tricks
  • Tahreem24's avatar
    Tahreem24
    7 years ago

    Hi Anonymous,

    I have created step by step solution for you.

    Please mark my answer as a solution so that it may helpful for others.

     

     

     

5 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    7 years ago

    Hi,

     

    I might have found the answer of your question. You can achieve this using What-if-Parameter. 

    I have created sample of your data and achived the expected result in below screen shots.

     

    User Input is 2User Input is 4

  • Tahreem24's avatar
    Tahreem24
    Super User
    7 years ago

    Hi Anonymous,

    I have created step by step solution for you.

    Please mark my answer as a solution so that it may helpful for others.

     

     

     

    • Tahreem24's avatar
      Tahreem24
      Super User
      7 years ago

      Hi Anonymous ,

       

      I hope I answered your doubt so please mark my effort as a solution :). It may also help others.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Thanks it works for me.

         

        Appreciate your Help.