View original (French)

BO issue (max function)

Ludovic -  
 saly31 -
Hello,

I’ve been using Business Objects (version 4.1) for a very short time. I have a problem: I need to query an history table (several rows for the same customer) but I only want to retrieve the last row (the date closest to today). I think there is a max function but I’m not able to use it.

If you have already encountered this problem, please help me.

1 answer

  1. saly31
     
    Hello

    You can use the extended syntax of conditional operators with the Max() function. For example, in a block containing <Department>, <City> and <Revenue>, the formula Max(<Revenue>) In <Department> returns the highest revenue per department.

    Best regards
    0