Problem in Set analysis

[munna1317]

hi QVs,

Plz help me the requirement is in Excel plz help

regards harish

[munna1317]

hi QV's,

Anyone With Answer ?, I can Close The Thread.

Regards ,

Harish

[avinashelite]

Sorry , i was bit busy ...Working on it

[munna1317]

thanks Avinashelite,

me to working on it if any solution plz let me knw,

Regards,

Harish

[munna1317]

hi QV's ,

Any Solution

regards,

Harish

[avinashelite]

Hi Harish,

I found the issue, the  flag  is not getting set properly and second issue is....for numbers more than 5digits

eg 148466 you expecting as 14+1 but its reading as 1+1 so your getting the value 20000

I am half way done , but got busy with work....I am attaching the document please try to continue with this as base

[munna1317]

hi avinash ,

Thxs for rply , what you have say is exactly correct ,

148466 you expecting as 14+1 but its reading as 1+1 so your getting the value 20000

I am also working on same expression ,

thxs once again ,

Regards ,

Harish

[munna1317]

hi Avinashelite,

i have got the result but the small problem , can you plz find out this i have gave expression:

If(Name=Previous(Name) and Div(CumulativeSum,50000)<Div(Previous(CumulativeSum),50000), Ceil(CumulativeSum/50000)*50000, Mod(CumulativeSum,50000)) as NewCumulativeSum

here iam getting error is

at

Name	Date	Year	Sales	CumulativeSum	NewCumulativeSum	Commission
Harish	12/08/2014	2014	7410	50594	594	0.01

here only it is rounding can plz help in this

[avinashelite]

Hi Harish,

Check this solution:

[avinashelite]

Hi Harish,

Please post the Exact Output what to  want, so that i can cross check.

[munna1317]

hi avinash,

Plz Check Exact Output

Regards,

harish