Forum Discussion

WalidMekky's avatar
WalidMekky
Frequent Visitor
8 years ago
Solved

Grid Calculation with measures

Hi All,

I almost new to know such a thing, so you help will be apprciated.

Simply, I have some values of table,

I pick each value and get its sutable exchange rate and multiply.

My issue now just like the attached picture.

The sum of the final value after multiplication is totally wrong, as the grid get sum of value and rate column and multiply.

The right sum should be 2.28 instead of 26.97

What to do ?

Value is from the table where fx_selected_rate is a measure get the right rate and fx_value_all is another measure to multiply.