Forum Discussion
Help with Measure
Hello all, Can you help me to find the error, the measure below shows repeated values in the column which is wrong. CAD_Over_GAP%_QYTD = Var CAD_Sal_QYTD = [Sales_CAD_QYTD] Var CAD_Bgt_QYTD = ...
What result are you seeing?
Without data, it is hard to reply. Let us go iterative phased approach here:
-- Test 1, what data you see? is it same as other column! cool!
CAD_Over_GAP%_QYTD = [Sales_CAD_QYTD]
-- Test 2, what data you see? is it same as other column! cool!
CAD_Over_GAP%_QYTD = [Bgt_2025_CAD_QYTD]
-- Test 3, what data you see? Is the formula working per the data?
CAD_Over_GAP%_QYTD = Divide([Sales_CAD_QYTD], [Bgt_2025_CAD_QYTD],0)
Looks like you have calculated logic in the two measures you used and hard to reply, without knowing the details and data.