Where have my MIN() and MAX() formulas gone?

[BlackrazorNZ]

Hi,

I'm working through migrating a report we do regularly to PowerPivot, as I can see huge time savings once it's been properly set up once.

However, I've hit a brick wall, because one of things we need to work out as follows :

Column 1 : Value 'A'
Column 2 : Value 'B'
Column 3 : Value 'C'
Column 4 : Divide 'A' by 'B' to get resultant ratio 'D'.
Column 5 : Multiply 'D' by 'C' to get 'E'.
Column 6 : Existing fixed value 'F'
Column 7 : Take whichever of 'E' or existing value 'F' are the greatest, and use that resultant value as 'G'

In Excel, this is easy, =MAX('E','F'). But for the life of me, I can't figure out how to replicate the last part in column 7 in PowerPivot.

Any ideas?

Thanks,

Daniel.

 

[BlackrazorNZ]

This is starting to drive me a bit bananas. I can absolutely see the huge potential with PowerPivot, but it seems that the designers have ommitted some of the most simple comparative calculation options.

Working out analytics over a column is great, but if I can't create a calculated column for even basic concepts like 'Fill the rows in this column with the higher of 2 values in each row of these other 2 columns', or 'If the value is less than zero, set the value to zero instead', we're really going to struggle to make it work for what we want to use it for

 

[scottsen]

You going to have to use an IF(). =IF(E > F, E, F)

 

[BlackrazorNZ]

Thanks for that, hadn't thought about using IF's. Equation is pretty complicated but it works