Upcoming Events

Weekly BMW races on Simracing.GP Other regular AC events on Simracing.GP Weekly GT3 Sprint Races on Simracing.GP Rookie friendly WTCR sereis Weekly rFactor 2 events

SimHub Functions

DND

Stay Safe, Healthy and be Kind - Stop Hate
Premium
Messages
1,869
Points
1,992
Post here if you need help, or can provide it, to write functions within SimHub.
I'll start.
Goal:
Leaderboard last lap time will change color based on previous and best lap. 'A' would be my personal lap time and is what the formula is based on.

I created a formula in Excel I know works, I just need help in how to make it work in ncalc for SimHub
=IFS(LAST LAP=PREVIOUS LAP,"Yellow",LAST LAP<BEST LAP,"Purple",LAST LAP>PREVIOUS LAP,"Red",LAST LAP<PREVIOUS LAP,"Green")

I have tried this:
if([CurrentLapTime]<[BestLapTime],PURPLE,if([CurrentLapTime]<[LastLapTime],Green,if([CurrentLapTime]>[LastLapTime],Red,Yellow)))

And this:
if([CurrentLapTime]<[BestLapTime],PURPLE,[CurrentLapTime]<[LastLapTime],Green,[CurrentLapTime]>[LastLapTime],Red,Yellow)

Not having much luck with either so some help is required, please.
1618681233963.png
 
Last edited:
Top