Forum Discussion
Calculated column rows do not return values for all rows
Hi Sai_Alkesh ，
Please remove any relationship between currency and sales table, and you can get the expected result...
Remove relationship
Best Regards
amitchandak - it still gives the same result. The reason i have the period in the filter clause is, 'cos i want to get the inverse value of FX rate which is for that period. Once i get that rate, i want to multiply the sales from Sales table with this derived rate.
In the calculated column of Sales table, it shows me the result of the derived value, however it only shows where the period in sales table is '20214'
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.
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.