Skip to Content
0

if statement in embedded summary calculation

Mar 13 at 09:16 AM

14

avatar image

Hi all
I posted a message previously:
https://answers.sap.com/questions/420565/adding-a-calculated-member-in-a-cross-tab-report.html?childToView=420577#answer-420577, trying to get a calculation based on the total of the group (Abhilash assisted). I put it on hold and came back to it now.
I decided to try an embedded summary. Please see the pic below as to more or less what I want to do:

I have used this, but it is not working...
if "JE.UMA-FSBClass" Like "*-Liability - Directors & Officers*" then gridvalueat(CurrentRowIndex, CurrentColumnIndex,0) * 12.49 /100 else if "JE.UMA-FSBClass" = " " then gridvalueat(CurrentRowIndex, CurrentColumnIndex,0)

Please help... THank you
Jerusha

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers