We have loaded a table into Qlik. It consists of two time dimensions and a key figure "Net value USD". The two time dimensions are "Month" and "Year".
The following formula works for "Month", but if we check the values on "Year" we find wrong results. This takes place only if we select more than one year in the filter.
Sum([Net value USD])/Sum(Total <Month> [Net value USD])
How must I adjust this formula to get correct results also on year?
