.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Percentages

Posted By:      Posted Date: October 09, 2010    Points: 0   Category :Sql Server
 

Good day, i need help please - not sure if i have to post on SSIS

The problem i have is that a percentage colume in my table, when i sum the total = '100.0000000'

This fine, but when i insert in SSIS & i preview the data in Lookup taks the Total = '100.072' which makes my calculations incorrect.

is there something i need to do to keep it in its original sum - but i view my decimal places in advanced properties decmal(38,12) so this should be fine.

Is in the query that i have to perhaps force it to be 100.0000, how?   

Can somebody please direct me on what i should do

Regards

 

 




View Complete Post


More Related Resource Links

Percentages in crystal report

  

 Hi all, please i have this type of data and i need help

Etisalat  - Group

Media          May            June

TV Total       566484      687585

Radio Total  273848      734849

 

GlobaCom - Group

Media          May            June

TV Total       373644      675738

Radio Total  172736      436487

 

how can i format my report to achieve something like this:

 

Etisalat  - Group

Media          May            June

TV Total       566484      687585

                    60%           53%

Radio Total  273848      

How to get percentages for each row values

  
Hi All, My source is like this... column1  totalSum(column1 sum)       2            14                   3            14                   4            14                   5            14               how to get percentages for each row values..I need query for this type of output... column1  totalSum   Percentage(Column1/totalsum)*100    2           14               14.28      3           14               21.42    4           14     &nbs

How to get percentages for each row values

  
Hi All my source looks like.... column1  totalSum(column1 Sum)       2           14                   3           14                   4           14                   5           14               how to get percentages for each row values..I need query for this type of output... column1  totalSum   Percentage(Column1/totalsum)*100    2           14               14.28      3           14               21.42    4           14          

SSIS - Lookup Percentages values change

  

Good day, i need help please.

The problem i have is that a percentage colume in my table, when i sum the total = '100.0000000'

This fine, but when i insert in SSIS - Lookup & i preview the data in Lookup task the Total = '100.072' which makes my calculations incorrect.

is there something i need to do to keep it in its original sum - but i view my decimal places in advanced properties decmal(38,12) so this should be fine.

Is in the query that i have to perhaps force it to be 100.0000, how?   

Can somebody please direct me on what i should do

Regards

 


What is the Expression for calculating Sum of percentages in SSRS report.

  

Hi All,

I want to calculate Sum of percentages in my SSRS report.

I have two fields :

Field1   Field2

For Field1 I am using the following formula --- Fields!suminsured/Sum(Fields!no.ofRisks) * 100

The  Field1  formula is working correctly....

Now I want to calculate Field2 from  Field1 ....

My Field2 Formula is Sum(Fields!suminsured/Sum(Fields!no.ofRisks)*100) --- But when I am doing this way its giving error...

Can any body let me know how to acheive Field2 ....??

Field2 is nothing but Sum(Field1) ....But for Field1 I am using Percentage Forumula....So field2 should be Sum(Field1) percentages....

Any ideas in this regard will be appreciated...

Waiting for the responses..

Thanks,

 


vineesh1701

calculate percentages in SQL

  

Hey there,

I have the following query:

UPDATE Invoice SET Local = CAST(( -- This gets the SupCommVATRate once being updated from the booking table SELECT SupCommVATRate FROM Booking WHERE ID = B.ID ) * ( SELECT Local FROM Invoice WHERE SourceID IN (B.ID, B.QuoteID) AND Notes = 'Supplier Com' AND Cat=3 )/(100+ ( SELECT SupCommVATRate FROM Booking WHERE ID = B.ID )) AS NUMERIC(9, 2))

FROM Booking B INNER JOIN Quote Q ON Q.ID = B.QuoteID INNER JOIN Invoice I ON I.SourceID = B.ID WHERE B.Depart + Q.Nights >= @StartDate AND B.Depart + Q.Nights <= @EndDate AND I.Notes = 'Supplier Com VAT'

What i need to do is update a value  in a table by a given percentage. But it doesn't seem to work. For example, take the above query:

SELECT	SupCommVATRate 
FROM	Booking 
WHERE	ID = B.ID

This will give the percentage value that we would multiply by, so these values are stored like so, 10.00, 20.00, 90.00 etc. 10.00 being 10% an so on.

So when i run this query i am trying to get 10% of 57.33 and UPDATE the ?"Local" field with the value which should be 5.73 BUT i am getting 5.21???

Can anyone please help me out?

Many thanks.


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend