7 Replies Latest reply on May 5, 2014 11:12 AM by SriniVEERAVALLI

# Complex calculation

Dear sir,

Example

I have 2 column , A and B

And need to calculate C is come from A - B

But I need value from normal (Sum) aggregate for A but I need value from "Last" aggregate for B

In report I can select Aggregate option for A and B

value of A and B show correct (from requirement)

But  when I calculate C , it use sum A - sum B

So my question is how I calculate C by sum(A) - Last(B)

And my constrain is B is come from lookup function in OBIEE so I can't put last function in OBIEE Admin formula.

Thank you

• ###### 1. Re: Complex calculation

Can you share sample data and with expected output.

Just wants to know the criteria for the LAST record

• ###### 2. Re: Complex calculation

Hi this is picture for your request. I can't upload pic here.

http://s17.postimg.org/md77aa867/ABC.png

• ###### 3. Re: Complex calculation

Did you try bottomn function?

something like this.

Sum(MeasurecolumnA) + Bottomn(MeasurecolumnB,1)

Thanks

Aj

• ###### 4. Re: Complex calculation

The criteria to get the 70 value is Last Month!!

is that right?

• ###### 5. Re: Complex calculation

I'll try thanks

• ###### 6. Re: Complex calculation

not lastmonth, it's look like last period for that Qtr thanks

• ###### 7. Re: Complex calculation

what "looks like"? this is your report you should know right...

Yes  its too complex!!