Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
this is my issue i have this kind of data set :
I would like for each op calculate lthis expression q*price/sale and have this amount as a row of a table.
thanks for your help guys.
regards
Try this attached and let me know?
this is exactly what i wanted to do. my problem is that the script you used is making an error i can't use it my data
Final:
LOAD Operation,
Sum(montant_affaire) AS Mnt_Affre
Resident
Data
Group by Operation;
Can you send me your actual script ? And the expected Graph you are looking for ? Can you send me the output you want as a screenshot if possible?
As you can see in the attached file i adapted your script for my need but it makes an error does'nt recognise de operation field and i can't get the mnt-affre field
Ahhh I thought so. You have some special alphabet characters in your field names. Use the below script in your QVW file and let me know? Change those field names from special character e to normal e in your excel sheet and use below script.
The letter e has a small apostrophe on the top.
Data:
LOAD Operation,
Qte,
Mnt_Net_client,
TF,
gdf,
(Qte*Mnt_Net_client) AS montant_affaire
FROM
(biff, embedded labels, table is Feuil1$);
Final:
LOAD Operation,
Sum(montant_affaire) AS Mnt_Affre
Resident
Data
Group by Operation;
hello,
the error was my use of resident data.
I really thanks you for your support.
regards.
Can you send me the actual script you are using and the error screen shot you are getting ?
Hello,
It is now working. I have no more error.
Thanks for your support.
Ragards