Run a fórmula under two conditions

Is there a way that once I select Milestone1 Multiple Choice (dynamics) and the Real1 have a date, this formula will be executed (first((select Milestones where Id = 1).…

Script problem.

do as server let me := this; for i in select 'Task templates' do let new := (create Tasks); new.( void; Status := 1; 'N1 Main Table' := me; 'Assigned Date' := date(year(me.'Start date'), month(me.…

• Answered

Need Formula on Chart

I have a multiple selection dynamic let uni := unique(((select Gastos) order by Categorias).text(Categorias)); for i in uni do first((select Gastos)[text(Categorias) = i]) end Copy I need the Formula…

• Answered

Formula to sort month

@Fred Hi Fred. Need to sort the graphic from Jan to Dec, the data is in the Gastos table (the gray data). I try this but don't work select Gastos order by month(this.Mes)

• Answered

Problem with this formula

sum((select Expenses).'Amount Spent' where Categories = "Gas") sum((select Expenses).'Amount Spent' where text(Categories) = 8) Where Categories is a Choice field.

• Answered

Total of the selected option

let vRaiting := "minRt: " + text('min. Raiting') + "| maxRt: " + text('max. Raiting'); let vRtMin := 'min. Raiting'; let vRtMax := 'max. Raiting'; let myFilter := trim(this.…

• Answered