Hello,
in a matrix report I created a bucket field and, based on this, I created a summary level formula column wich results valid but is not working as expected.
This is the formula:
IF(BucketField_22897182="Licence", Opportunity.Amount_MT__c.CONVERT:SUM*3+AMOUNT.CONVERT:SUM, AMOUNT.CONVERT:SUM*3)
When I run the report, results for "Licence" is AMOUNT.CONVERT:SUM*3
instead of
Opportunity.Amount_MT__c.CONVERT:SUM*3+AMOUNT.CONVERT:SUM
What did I get wrong?
4 Antworten
Hi Mimma,
I did some research and Unfortunately, you won't be able to do that in a Report Summary Formula like that. You'll need to create a Formula field on the Object itself and then reference that in your Report. If statement is not possible with a bucket field.
