This is what my script looks like.

THis is where the error is coming from:

$Row.StdMargin_Pct = $_.StdMargin_Pct

$global:currenttime= Set-PSBreakpoint -Variable currenttime -Mode Read -Action { $global:currenttime= Get-Date }

Write-host "Starting...

Awesome Man!!!!

Thanks..

If I get a divide by zero error any way to code around that, over figure out the data causing the error?

Thanks.

Very Nice that's what I was looking for...

MANY THANKS !!!!!!!

Use these records as it should bypass them on the output. It has same MEID and entity and channel, the prodline is different but that

shouldn't matter since charges are split...

Let me send some more sample data..

THanks.

It seems to be working, except it should Only display where there is a split costs between channel and entity. If it's all for the same entity\channel no matter if...

I had the data ordered wrong coming out of the cte, but did notice the percentages are off when Prodline isn't populated When

a meid has multiple items, but the Prodline...

Any code suggestions, and how to run multiple process against the data?

THanks.

I forgot the last statement in the code:

WHERE PctofTotal < 100;

But even with this I was still getting records at 100% with a single meid and single entity\channel. I did...

When I run it on my live data I'm also get a:

Divide by zero error encountered.

Thanks..

drop table #MonthlyChrgs ;
CREATE TABLE #MonthlyChrgs 
        (
         tmp_channel   ...

The query is rolling up the channel,entity and Prodline and giving a total for tmp_charges along with a percent. I was looking for ONLY where a tmp_meid has different entity\channels...

I'm not sure how to verify that I have a single tmp_meid spread across multiple tmp_Channels. If I hard code in the tmp_meid

that I know is broke out like this...

Each one of the import records from the queue are processed with the cursor, as the count from the capture is associated with a TEST. I went ahead and created...