Display dashboard field through combining two fields values

Kinetic ERP
, , ,
1

I am utilising the SLS and need to display a column in a customised dashboard based on two fields in the opportunity/quote entry form inside the tasks tab. Essentially these fields are manually input as tasks to be completed for the opportunity/client.

The column will be titled “Date of Last Contact” and has to pull from these two below values highlighted. The logic I want is as follows: Display the “Start Date” only if the “Seq Num” is = ‘120’

image
image1034×893 106 KB

For context there are a bunch of tasks that all have different sequence numbers, All I need is the seq num that equals ‘120’.

These are the bindings for each field:

image
image1568×532 203 KB

image
image1639×406 131 KB

The dashboard is using a BAQ. I am wondering what the best approach would be to display this column, it’s simple to display these two fields in the BAQ separately however would I need a calculated value that stipulates if the Task.TaskSeqNum = ‘120’ then display Task.StartDate?

2

Something like

case when Task.TaskSeqNum = 120 then Task.StartDate

I’m on the phone so backticks are hard

You’ll have to determine if you need null checks or nested cases

You could also do this with a windowing function