Discussion board where members can learn more about Qlik Sense App Development and Usage.
Can someone help me on below scenario.
We have Budget , Forecast1 and forecast2 by month and also we have Budget_Rate, Forecast1_Rate and Forecast2_Rate by month.
There is calculation for month Jan as
=(Jan Forecast2/Jan Forecast2_Rate) will consider as Jan_EUR
For Feb month we have calculation
=(Jan_Eur+((Feb Forecast2 - Jan Forecast2 )/Feb Forecast2_Rate)) as Feb_EUR
For Mar month
= (Feb_EUR++((Forecast2 of Mar month - Forecast2 of Feb Month)/Mar Forecast2_Rate)) as Mar_Eur.
Next every month we have same calculations.
Can you please help me to calculate Jan_Eur,Feb_Eur,Mar_Eur,...........Dec_Eur.
We have to perform this in backend and the will do Sum of Jan_Eur,Feb_Eur, etc.. in frontend.
Would you be able to provide some sample data and the output expected from it?
PFA: Sample data for scenario.