Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
My requirement is that I have certain fields as the range 0.00734836 , and 0.00865531.But I want that to convert to 734836 , 865531.
Can anyone please suggest me how to resolve the above issue.
Thanks
Try this num(Replace(YourExpression,'.','0'),'###0')
Can't you simply multiply it by 100,000,000?
Jul 2012 | Aug 2012 | Sep 2012 | Oct 2012 | Nov 2012 | Dec 2012 | Jan 2013 | Feb 2013 | Mar 2013 |
109496881 | 125000408 | 91763668 | 74423870 | 218582 | 110745 | 132 | - | 132 |
175683959 | 177580227 | 187505518 | 109387046 | 66853791 | 833101 | 132 | - | 132 |
206106912 | 212271175 | 213210826 | 177236626 | 136155011 | 80316481 | 2218367 | - | 132 |
299699999 | 246357956 | 233346207 | 205481902 | 192303659 | 197206116 | 127132027 | 1717628 | 132 |
516298796 | 459274400 | 360637259 | 384951707 | 260670499 | 256329558 | 209245170 | 107842259 | 1427046 |
533778773 | 487892890 | 434772720 | 356419051 | 287547755 | 277546784 | 265527216 | 195477413 | 29323847 |
569576058 | 470208378 | 471122028 | 398393200 | 303443637 | 289799440 | 279432834 | 241178401 | 54798763 |
552656986 | 568360016 | 445750914 | 428515354 | 383343252 | 384440438 | 375240475 | 288094885 | 68660947 |
1.698E+09 | 690169653 | 686661323 | 685733012 | 418394958 | 1.868E+09 | 299726957 | 273977181 | 82455852 |
395828720 | 1.588E+09 | 530894104 | 495839159 | 462859317 | 1.92E+09 | 361807638 | 295905731 | 110429205 |
10917125 | 178728125 | 1.747E+09 | 720960262 | 551374428 | 545209672 | 550860917 | 443774464 | 259298231 |
- | - | - | - | 0.0036421 | 0.0033959 | 0.0039948 | 0.0041294 | 0.0025708 |
- | - | - | - | 0.0073486 | 0.0086553 | 0.0053192 | 0.004468 | 0.0020597 |
I am using the expression
(Sum(distinct([Supply Plan])))
& num(if(Plan_For_Month >=monthstart(today()),Sum(distinct([Supply Plan 1]))))
and dimension is two month field.
The highlighted dark numbers needs to be changed from 0.0073486 to 73486.
But if I multiply it to 100,000,000 then all the values gets changes .But that should not happen
Please advise some solution to the above problem
cud u pls post ur expression, is the expression which u've posted i sthe actua; expression ?
can't u simply check,using if, the sum returned is less than zero,then multiply by that figure ?
It is only for certain months the values needs to be modified and it can't be multiplied because on the whole it gets multiplied for the whole table
I tried but it not works
Hello,
Hope it helps you.,..according to your first post.
Num(Trim(Replace(Field1,Left(Field1,2),''))) as Field1
Cheers!!
Jagan Nalla
I tried it but still the same problem persists
Try this num(Replace(YourExpression,'.','0'),'###0')