Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to use the following equation to get a color if value if between -5% and 5%.
For some reason, it is not working. could any one advise.
IF( $(vAcc) >= -0.05 <= 0.05 , $(vTemplate_GSK_SecondaryColour4_1), $(vTemplate_GSK_SecondaryColour2_1))
IF( fabs($(vBias)) <= 0.05 , $(vTemplate_GSK_SecondaryColour4_1), $(vTemplate_GSK_SecondaryColour2_1))
Hi, try with :
IF( fabs($(vAcc)) <= 0.05 , $(vTemplate_GSK_SecondaryColour4_1), $(vTemplate_GSK_SecondaryColour2_1))
Try like:
IF( $(vAcc) >= -0.05 AND $(vAcc) <= 0.05 , $(vTemplate_GSK_SecondaryColour4_1), $(vTemplate_GSK_SecondaryColour2_1))
it did not work, hence i was contacting the community.
IF( fabs($(vBias)) <= 0.05 , $(vTemplate_GSK_SecondaryColour4_1), $(vTemplate_GSK_SecondaryColour2_1))