Forum Discussion
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...
Hi Sai_Alkesh ，
Please remove any relationship between currency and sales table, and you can get the expected result...
Remove relationship
Best Regards
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)
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.
Hi Sai_Alkesh ，
Please remove any relationship between currency and sales table, and you can get the expected result...
Remove relationship
Best Regards