I have a question to an ongoing problem I am having. Based on the forums, I see there is a way to force 2 decimal places. However, I do not understand how I would force to decimal places in the subject report. For example, I create a table manually and input 2 formulas to calculate the gap score. The formulas individually force to decimal places, but once combined they do not. Is there a workaround?
The formula used to calculate the gap score:
$e{ round( ${rp://Result/DS_5AVzzCECvrPV0pf/SD/SC_50Yjd98AUiZPMOx/weightedMean} - rp://Result/DS_2mFqF8vndwwE817/SD/SC_50Yjd98AUiZPMOx/weightedMean , 2 ) }
Also when I pipe in the dimension score in my conditional text it all of a sudden doesn't force 2 decimal places like it does in the picture above. Is this something you can help me with?
Page 1 / 1
Hi jsorrells, I think you may have a slight syntax error in your formula.
Can you try using this -:
$e{ round( ${rp://Result/DS_5AVzzCECvrPV0pf/SD/SC_50Yjd98AUiZPMOx/weightedMean} - ${rp://Result/DS_2mFqF8vndwwE817/SD/SC_50Yjd98AUiZPMOx/weightedMean} , 2 ) }
Cheers,
Cameron
Leave a Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.