Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Circular Dependency

Hello,   I have monthly rolling forecast for all subsidairies. Raw data (Column A~E) is like following. G3, H3 & I3 were calculated by other formulas. Please advise how to calculate rest cells for ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi. Below is the sample data. Please advise how to solve it in Power Query. Thank you very much

ProductCompanyMonthForecast DueThis month ForecastPrevious Month ForecastM0 C/FM0 RemAfter M0 FC
Car 1AAAMonth 011/1/20242    
Car 1AAAMonth 012/1/202412100
Car 1AAAMonth 021/1/20242    
Car 1AAAMonth 022/1/2024120 =IF(E5>=H3,H3,E5)0 =H3-G51 = E5-G5
Car 1AAAMonth 031/1/20242    
Car 1AAAMonth 032/1/2024720 =IF(E7>=H5,H5,E7)0 =H5-G77 = E7-G7
Car 1AAAMonth 041/1/20241    
Car 1AAAMonth 042/1/2024110 =IF(E9>=H7,H7,E9)0 =H7-G91 =E9-G9
Car 1AAAMonth 051/1/20241    
Car 1AAAMonth 052/1/202411001
Car 1AAAMonth 061/1/20241    
Car 1AAAMonth 062/1/202411001
Car 1AAAMonth 071/1/202412    
Car 1AAAMonth 072/1/2024412004
Car 1AAAMonth 081/1/20243    
Car 1AAAMonth 082/1/202433003
Car 1AAAMonth 091/1/20243    
Car 1AAAMonth 092/1/202443004
Car 1AAAMonth 101/1/20241    
Car 1AAAMonth 102/1/202401000
Car 1AAAMonth 111/1/20240    
Car 1AAAMonth 112/1/202400000
Car 1AAAMonth 121/1/20240    
Car 1AAAMonth 122/1/202400000
Car 2BBBMonth 011/1/2024     
Car 2BBBMonth 012/1/2024     
lbendlin's avatar
lbendlin
Super User
2 years ago

Why is H3   resulting in 0 and not in -1 ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,

     

    Actually, there is another column to the left of "M0 C/F", called "Remainder".

    H3 is Remainder - M0 C/F, so it's 1-1=0.