I have an expression that uses division but it always returns zero. Here some examples of what I have tried:
=RunningValue('group1',Count(Fields.[Short Description])) / Exec('Report1', Count(Fields.[Short Description]))
Returns 0
=RunningValue('group1',Count(Fields.[Short Description])) / 64
Returns 0
=Count(Fields.[Short Description]) / Exec('DuplicateCARs', Count(Fields.[Short Description]))
Returns 0
=(3 /15)
Returns 0
The cell is formatted as a number with 2 decimal places assigned.
The running value does in fact return an int every time, I have tested it. So, why does this expression always return a zero? All other math opperators work fine; addition, multiplication and subtraction.
=RunningValue('group1',Count(Fields.[Short Description])) / Exec('Report1', Count(Fields.[Short Description]))
Returns 0
=RunningValue('group1',Count(Fields.[Short Description])) / 64
Returns 0
=Count(Fields.[Short Description]) / Exec('DuplicateCARs', Count(Fields.[Short Description]))
Returns 0
=(3 /15)
Returns 0
The cell is formatted as a number with 2 decimal places assigned.
The running value does in fact return an int every time, I have tested it. So, why does this expression always return a zero? All other math opperators work fine; addition, multiplication and subtraction.