Forum Discussion
Solved
Meassure Calculation
Dear all,
I am not able to obtain the right result. Could you help me please?
| Issues | Reporting | Calc | Real Estimated | |
| 35,35 | 143 | 107,65 | 107,65 | |
| 106,05 | 43 | -63,05 | 0 | Negative must be "0" |
| 187,6 | 75 | -112,6 | 0 | Negative must be "0" |
| 71,05 | 394 | 322,95 | 322,95 | |
| 122,85 | 163 | 40,15 | 40,15 | |
| 160,3 | 156 | -4,3 | 0 | Negative must be "0" |
| 105,7 | 198 | 92,3 | 92,3 | |
| 383,1 | 563,05 | |||
| MeasureCalc = IF([Issues]-[Reporting]<0;0;[Issues]-[Reporting]) | ||||
| Obteined wrong results "383,10" | ||||
| or this Calc | ||||
| (Issues-Reporting)*70%/2, If the result obtained is negative show "0" |
Hi ldbello ,
I have updated my test file. You could download and refer to it.
My sample data may be a little different with yours because I used whole number.
5 Replies
Please share the formula for the issue and reporting. Measure calculation depends(may) on the level where it happens so need to check that.
Thanks a lot,
I do not have any issue, just only want the calc without negavite values using one or two ways as commented:
The calc/form is: MeasureCalc = IF([Issues]-[Reporting]<0;0;[Issues]-[Reporting])
Expecting without negative values
(-63,-113,-4)Obtained Issues 35 106 188 71 123 160 106 789 Reporting 143 43 75 394 163 156 198 1172 Sum 108 -63 -113 323 40 -4 92 383 Sum 108 0 0 323 40 0 92 563 Hi ldbello ,
You could try the following measure:
Measure = SUMX ( 'Table'; IF ( [Issues] - [Reporting] < 0; 0; [Issues] - [Reporting] ) )
