understand the formula

[#1]

help me understand this formula

sum({$<Month=,Year_Month=>} Coverage_Achievement_Qty) / sum({$<Month=,Year_Month=>} Coverage_Target_Qty)

Calendar:

LOAD * INLINE [

    Year_Month

    1

    2

    3

    4

    5

    6

];

[robert_mika]

Is simple division of all  values from Achievement_Qty field by all values from Target_Qty

You could write this as

sum( Coverage_Achievement_Qty) / sum(Coverage_Target_Qty)

[jjordaan]

Hi Mohammad,

This expression is summarizing the Coverage_Achievement_Qty but it is disregarding the selections for Month and Year_Month.

It is doing the same for Coverage_Target_Qty.

In the end the outcome for sumarizing Coverage_Achievement_Qty will be divided by Coverage_Target_Qty