calculated field stuck being a whole number
I'm hoping this is just a simple thing I'm missing due to my lack of experience in Yellowfin.
In Calculated Field/Simple, I obtain the ratio of aggregations of a calculated field and a column, both of which are whole numbers:
SUM ( Eff_DTC2 ) / COUNT ( Case # )
I'd like the result to two decimal places, which it is, but the two are always ".00", which is not helpful. For example, with the numerator = 12001 and the denominator = 409, the result displays as 29.00 instead of 29.34. I even went back and changed the format of the two referenced fields to be 12001.00 & 409.00, but that didn't help either.
Do I need to explicitly fix two decimal places in the calculation? Something like:
DEC (SUM (Eff_DTC2),2) / DEC (COUNT (Case#),2)
as I've seen in other languages, but how would I implement this in Simple mode, assuming it was the ticket for my issue?
Appreciate any assistance/guidance.