I've made a rapport layout where i have made a summary of products. Per Product there is a subsummary of revenue of that product.
However the data is delivered by a third party where the value isn't set in currency but in flat data x 100.
So i made a calculationfield which picks up the Products_Total field and divides it by 100 after that i give the field a "currency-look" via the inspector with decimals and a €-sign.
This works great for the grandtotals but somehow i can't use the same trick for the subsummaries cause it displays the value from the grandtotal ?
Much oblidged for reading