Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
Is it possible to take elements out of a field and create new fields to do operations on those elements.
Say there is a file as such:
Forecast plan Customer Revenues (m)
F1 Bob 2.3
Mary 5.8
F2 Bob 3.1
Mary 4.7
F3 Bob 3.6
Mary 6.0
Luke 1.3
And it is necessary to find the deviations between F1, F2, and F3. How can new fields be created just for F1, F2, and F3 from the field "Forecast Plan"?
Thank you in advance for your response.
Regards,
Daniel
In a chart it is possible to create a synthetic dimension, for example:
=valuelist('F1','F2','F3','F4')
then link expressions to that list to perform different calculations:
if(valuelist('F1','F2','F3','F4') = 'F1', sum(ABC),
if(valuelist('F1','F2','F3','F4') = 'F2', sum(DEF),
if(valuelist('F1','F2','F3','F4') = 'F3', sum(ABC) - sum(DEF),
...
What do you mean by new fields? What do you want, the total forecasted revenue regardless of customer? Dimension of Forecast plan, expression of sum(Revenues). You wouldn't want to roll up data like that in the script. But I get the feeling that I have no idea what you're asking for.
Perhaps I'm totally wrong, but I could imagine you mean something like what I'm doing in my enclosed example.
In this you get a final table like:
Customer Revenues_F1 Revenues_F2 Revenues_F3
Bob 2.3 3.1 3.6
Luke 1.3
Mary 5.8 4.7 6.0
Rgds,
Joachim