Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to create a temporary table in the Script however i am a little unsure on the best way to go about this. I have attached an excel document that has soem exampel raw data and teh table i would like to create.
Any help would be appreciated.
thanks
dan
Hi,
See the file attached.
Regards,
Arjan
Hi Arjan
Thanks for the reply. That looks like it does the trick.
Would it be possible to add a Field to 'DetailStart' called 'Secondreporter1011' and update this (where fy=2010/11) based on the expression 'count(SecondReporter)/count(FirstReporter)'?
Ultimatly what i would like to do is use the 2011/12 ratio as an estimate for 2010/11 as no historical data is available.
Thanks
dan
Hi Arjan
Thanks for the reply. That looks like it does the trick.
Would it be possible to add a Field to 'DetailStart' called 'Secondreporter1011' and update this (where fy=2010/11) based on the expression 'count(SecondReporter)/count(FirstReporter)'?
Ultimatly what i would like to do is use the 2011/12 ratio as an estimate for 2010/11 as no historical data is available.
Thanks
dan
HI Arjan
I think i have done what i am trying to do based on your above sample but it would be great if you could take a look and let me know if there is a better way.
Kind regards,
Dan