Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi QVs,
Plz help me the requirement is in Excel plz help
regards harish
hi QV's,
Anyone With Answer ?, I can Close The Thread.
Regards ,
Harish
Sorry , i was bit busy ...Working on it
hi QV's ,
Any Solution
regards,
Harish
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
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
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
Hi Harish,
Check this solution:
Hi Harish,
Please post the Exact Output what to want, so that i can cross check.
hi avinash,
Plz Check Exact Output
Regards,
harish