File wizard transformation error

[#1]

Hi,

Can someone please try and help me to work out what's wrong with my script?

I'm having trouble getting the correct sum of forecast and growth value from the data. I think it may have something to do with the way I did the file transformation from in file wizard but I can't work out what went wrong.

As you can see the snapshot from my QVW file, my table shows that the sum of growth against Vendor FF for Customer1 in FY14 is $1,945,765.09 and sum of forecast is $1,945,765.09

However, if you look at my raw data, sum of growth for Vendor FF for customer 1 in FY14 should be $327,488.29 same goes to sum of forecast $327,488.29

Thanks in advance!

[#2]

Thanks Settu! The mapping is very helpful! will make my script neater. Cheers

[#3]

Hi Saurabh,

So what should I do to change it?

Thanks,

Susan

[PradeepReddy]

If you take distinct, and if multiple vendors have the same Forecast value, then it will consider only once instead of two.

So I tried to avoid the use of distinct in the calculation,see the attachment, it might be helpful for you... it is the extension of what settu.periyasamy did earlier. Hope it will help you..

[PradeepReddy]

Check with your team, to get more details..

check whether have to showcase the forecast/growth value at month level or Year level..?.

If Month level, u have to take the monthly forecast/growth value in data source.

[#6]

hmmmm some figures are still incorrect......