I'm trying to us a formula in a report which references a Bucket Field and equals a % depending on the Bucket Field label.
The formula I have is as below noted belwo, but my result is always 5% for all rows when I expect/hope to get 10% where the row is EICC. To clarify, I can never get the if statement to retrun 10% (TRUE). I believe I'm refferencing the Bucket Field correctly, but I can't seem to match the Label i.e. ="EICC' in this instance; The screenshot below also shows a little context. You can see two of the the Bucket Field labels i.e. EICC and QMS. To prove it worked I was hoping to to run the report and get 10% next to the EICC row, but the formula field shows 5% for everything and not 10% for the EICC row.
Thank you in advance,
Jonny
IF(BucketField_32228642="EICC",10,5)
8 answers
Hi Jonathan,
I dont think you can use Bucket Fields in that context.
I think the best way is to create a formula field on the Object and use that field in the report.
