Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
Thanks, sorry, doesn't work.... it gave me nulls instead...
oh nevermind.. it's the sum... Silly me, thanks!
So it's working now?
Yes! Thanks!