I discovered a value of "int" for "unvoided" <field reporter:label="Unvoided Billing Amount" name="unvoided" reporter:datatype="int" />
The view puts the total unvoided sum of money* into that column: sum( CASE WHEN b.voided THEN 0::numeric ELSE b.amount END) AS unvoided,
The datatype should be "money"
This affects reports
I discovered a value of "int" for "unvoided" label=" Unvoided Billing Amount" name="unvoided" reporter: datatype= "int" />
<field reporter:
The view puts the total unvoided sum of money* into that column:
sum(
CASE
WHEN b.voided THEN 0::numeric
ELSE b.amount
END) AS unvoided,
The datatype should be "money"
This affects reports