Using variables to forecast?

[Anonymous]

Hi, I am trying to calculate a quarterly forecast using current QTD runrates for 2 different dimensions (Business unit and segment). I was able to calculate the runrates for both but when I applied the runrates * the total EST using the following formula, it gave me wrong answers. Can someone help please? TIA!

sum(if(Segment = 'A', 200000, if(Segment = 'B', 300000, if(Segment = 'C', 400000, if(Business Unit = 'AA', 200000, if(Business Unit ='BB', ...)))))) * (Runrate/100)

Please see screenshot below.

[rustyfishbones]

Maybe you could try it like this

sum(if(Segment = 'A' AND [Business Unit] = 'AA',  200000, if(Segment = 'B', 300000 AND [Business Unit] ='BB' , if(Segment = 'C', 400000 AND [Business Unit] ='CC')))) * (Runrate/100)

[Anonymous]

Thanks, sorry, doesn't work.... it gave me nulls instead...

[Anonymous]

oh nevermind.. it's the sum... Silly me, thanks!

[rustyfishbones]

So it's working now?

[Anonymous]

Yes! Thanks!