Forum Discussion

SIBI1998's avatar
SIBI1998
Icon for Helper I rankHelper I
4 years ago

If Condition

Hi Team,                    I want an if Condition for this Query :   If the Derative Count is greater than gaurav Patel Target (Example :  Derative Count is 100 , gaurav Patel Target is 70 ) ,He...
SIBI1998's avatar
SIBI1998
Icon for Helper I rankHelper I
4 years ago

ValtteriN 

Given Solution is not working with in this case

ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

There was a ) missing:

//if Derative Count and  gaurav Patel Target are measures use them in place of variables

var DC = MAX(Table[Derative Count])
var GPT = MAX(Table[gaurav Patel Target]) return
IF(DC>GPT,(DC-GPT)*50,0)


What kind of error are you getting?