Forum Discussion

Oros's avatar
Oros
Post Prodigy
3 years ago
Solved

If statements

Hello.   Does this issue need a conditional measure? Any idea is highly appreciated.  Thanks.   I have the following product table and customer table.   For some reasons, the price that a...
Need Help
  • Chew_WenJie's avatar
    Chew_WenJie
    3 years ago

    Hi Oros ,

    according to the sample table, I am able to get the correct table. 


    Do the same customer have different pricing level?

Oros's avatar
Oros
Post Prodigy
3 years ago

Hi Chew_WenJie ,

 

Thank you for your update.

 

When the (new) column is created, a customer shows 3 different pricing level instead of only 1 pricing level.  The price that should show should only be $48.00.

 

When the (new) measure s created, the resulting table became blank.

 

 

 

 

Chew_WenJie's avatar
Chew_WenJie
Resolver III
3 years ago

Hi Oros ,

according to the sample table, I am able to get the correct table. 


Do the same customer have different pricing level?

  • Oros's avatar
    Oros
    Post Prodigy
    3 years ago

    Hi Chew_WenJie ,

     

    May I confirm the relationship between your tables?  For some reasons, the calculated column (PRICE) shows 3 pricing levels.  The only correct equivalent price is $12.00 for this pricing level. Maybe I am missing something here. Thanks.

     

  • Oros's avatar
    Oros
    Post Prodigy
    3 years ago

    hi Chew_WenJie ,

     

    Each customer only has one (1) pricing level.  Thanks.

  • Chew_WenJie's avatar
    Chew_WenJie
    Resolver III
    3 years ago

    Hi Oros ,

    Here is my relationship between the table.

     

  • Oros's avatar
    Oros
    Post Prodigy
    3 years ago

    Hi Chew_WenJie ,

     

    Thank you so much!