Data Actions - IF

[daianealves]

Hi!

How do I compare the two resultlookup, for example, I have the number in the indicator and I want to compare it with the other, how do i do it in the advanced formula (Data actions)? 
Well, what I did didn't work... 

Example:
 IF RESULTLOOKUP([] = "") <RESULTLOOKUP([] = "")

[N1kh1l · Accepted solution]

@daianealves 

IF RESULTLLOKUP(A) > RESULTLOOKUP(B), where A and B should be your dimensions and Measures is the normal construct. You can change the comparison operator as per your choice or change the dimensions within the lookup as per your requirement.

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/afe93e3cf1414a7b8419b...

Nikhil

Nikhil