Skip to Content
0
Former Member
Jan 23, 2013 at 09:07 AM

Range lookup in BO webI

26 Views

Hello Friends,

I got typical requirement to acheive in BO 4 webI.

Requirement : I have to create the variable/formulae in BO webI based on

below excel formulae.

If(SUM(L2:M2)=0,1,0) - Excel formulae

L = salesrevenue(measure value)

M = Revenue (measure)

How to we create the same formulea in BO 4 webI.

Can you please help on this. I tried using RunningSUM but could not sucees. I have attached the picture for reference.

In that attached screenshot we have columns called Cross Support and revenue, based on this columns in excel they have writtem formulae like

If(SUM(L2:M2)=0,1,0)

Regards,

Eswar





























































































































Cross
Support Revenue Variable 0 1 0 2 1 0 2 1 0 3 1 0 4 1 0 6 1 0 5 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 1 0

Attachments

Capture.PNG (17.8 kB)