on 08-27-2015 11:31 AM
Hello Experts,
I have to make a macro run only for the cells which have some values, i.e macro should not perform any calculation using blank cells.
Ex.
I want result as this
Quantity | 12 | 25 | 125 | 85 | 45 | 99 |
Price | 10 | 55 | 12 | |||
Total Amount | 120 | 4675 | 1188 |
---|
but the simple macro which I wrote gives the result as this, it is considering only the first value combination and then pasting result for whole of the iteration period.
Quantity | 12 | 25 | 125 | 85 | 45 | 99 |
Price | 10 | 55 | 12 | |||
Total Amount | 120 | 120 | 120 | 120 | 120 | 120 |
---|
How do we make this macro to perform the calculation for the nonmissing cells only.
Thanks.
Harshad M.
Harshad,
Write this default macro as follows:
New macro
New step : ( 78 Iterations : W 35.2015; W 07.2017 )
IF
New condition
Row: Key Figure Price ( Frm W 35.2015 )
> 0 (use operator / function for this)
Row: Key Figure Total Amount ( Frm W 35.2015 ) =
Row: Key Figure Price ( Frm W 35.2015 )
* (use operator / function for this)
Row: Key Figure Quantity ( Frm W 35.2015 )
ENDIF
I hope this will resolve your issue. If yes follow else raise your concern.
Regards
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
4 | |
3 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.