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