Forum Discussion

Sai_Alkesh's avatar
Sai_Alkesh
Helper II
4 years ago
Solved

Calculated column rows do not return values for all rows

Hi, I have 2 tables - Currency & Sales and they are connected by many to many relationship. I have created a calculated column in Sales table, and it returns value for only one condition, where the...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Sai_Alkesh ，

    Please remove any relationship between currency and sales table, and you can get the expected result...

    Remove relationship

    Best Regards

amitchandak's avatar
amitchandak
Super User
4 years ago

Sai_Alkesh , do you have rates other than 20214.

 

Can share a little bigger sample to test

Sai_Alkesh's avatar
Sai_Alkesh
Helper II
4 years ago

amitchandak - yes, i do. The currency table has the budget rate which is set to period 20214 for various currencies, however they are valid for the full year.

In Sales tables, since we have sales by individual month, we want to multiply the monthly sales with the budget rate.

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Sai_Alkesh , if there valid for a full year.

     

    I will add the year in both tables and join that instead of period

     

    year = left([Period year],1)

    • Sai_Alkesh's avatar
      Sai_Alkesh
      Helper II
      4 years ago

      amitchandak , thanks for extending the support. I tried as suggested, however its the same output. 

      I even tried with lookupvalue, since Filter was iterative, hence leaving blanks for period other than 20214, however it doesnt work either.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Sai_Alkesh ，

        Please remove any relationship between currency and sales table, and you can get the expected result...

        Remove relationship

        Best Regards