Skip to main content
A
Avatar-Roku
Newcomer
February 14, 2022

How do I override CV cells?

  • February 14, 2022
  • 1 reply
  • 0 views

I have a report that uses it's own conditions to calculate a value. Is their a way to over-ride the blank/data cell in cube view, and have it run a simple IF conditional calculation?

Most of these conditional calculation are for KPI's (basically forecasting for 2023 and on..).

One of the condition within excel I'm referencing. 

 

Mustafa_A_0-1644865147431.png

 

Would appreciate your suggestions. Thank you!

 

Best,

Mustafa

 

 

1 reply

E
EdWatson
Newcomer
March 11, 2022

Hi Mustafa,

If you have the CV hosted in a dashboard then a simple button to run through to a Business Rule would be your best approach.  Here you can bring in your variables then run the IF function to set a different formula dependant on if you X value is greater or smaller then your Y value. Typically the sub would look like the below (note this is a very simplified version):

 

Dim Xi as integer = api.data.getdatacell({intersection for X}).cellamount * (1 + api.data.getdatacell{intersection for I}).cellamount

Dim Y as integer = api.data.getdatacell({intersection for Y}).cellamount

api.data.clearcalculated(true, true, true, true, "{intersection to calculate to}")

If Y > Xi then

api.data.calculate([intersection to calculate to] = Y)

Else

api.data.calculate([intersection to calculate to] = X)

End if

 

Regards,

Ed

Terms & ConditionsAccessibility statement