Hello Community,
I am attempting to perform an if statement and did not know if it is possible. Also, not sure if the syntax is correct (see below). Additionally, can I do the if statement on row 2 and forget about row 1?
type | name | label | calculation
row1
integer | PersonRateCalc | Personnel Rate Calculation | if(${CostCode}="8946",pulldata('ResourceRates','Rates','name',${Label})
row 2
integer | Hourly Cost | Others Hourly Cost | ${PersonRateCalc}
Best,
Christopher
