CrossTab Reports - Getting minimum of each row
i am working on a crosstab report in which i want to highlight minimum value in each row. there is a function that displays minimum of each row in last column but i want that particular value to be highlighted instead of displaying it in last.
For details, it is a comparative report for quotations. i have multiple supplies quoting price for items. i want to highlight min price of each item.
i tried to apply condition on highlighting field value using following condition:
value = MIN(<quotations."amount">,MasterData1,0)
but this doesn't seem to work.
any idea what i am doing wrong ... plz
For details, it is a comparative report for quotations. i have multiple supplies quoting price for items. i want to highlight min price of each item.
i tried to apply condition on highlighting field value using following condition:
value = MIN(<quotations."amount">,MasterData1,0)
but this doesn't seem to work.
any idea what i am doing wrong ... plz
Comments
Mick