Rafael's Profile | Ninox community

Badges

Latest Posts

Re: Suggestions from May 2022
The most important thing here is that Ninox solves the bugs first, and then at least Plan some of these ideas and make them come true at least one or two
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- 1
- Learn and share
- Reported - view
Re: How to Calculate Cumulative Sum
@John Halls Great , Thanks very interesting explanation John
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
@John Halls Hi John, some technical for me 👍 maybe work for me because each time I cutoff I delete ALL the Progress Table and generate all New one. I have Two button on Table CUTOFFDATE when finish…
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
@John Halls Hi again John, Early this morning on my mockup I was working, I have 9 cutoffdates in my DB, I do 18 cutoff and work fine in all. I will try again in afternoon.…
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
@John Halls Hi John, thanks for new ideas, so far it's working fine, if you have any better ideas you'll be welcome, I have no idea of programming, it's taken me a long time to get to where I am…
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
@Fred Great Fred Now Have the Cost by Week and the Cumulative Cost and can represent the Curve with the Plan - Earned and Cumulative Cost Thanks Fred.
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
@John Halls Thanks John appreciate.👍
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
@Fred Yes Fred Work Great Work. 👋 Thanks a lot
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
@Fred Yes Fred is EVM-7-1_Junio.Ninox Upload again
Attachment
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
@Fred The DB
Attachment
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
@Fred the formula give me this result, All Id's on COST_W
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
@Fred Hi Fred the Formula give me 0.00€ I place the Formula on EV_Management is in field RED Name FredFormula. The other table is COST_W where I have all the cost by Week.
Attachment
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- Get help
- Reported - view
How to Calculate Cumulative Sum

I have this info on my Table COST_W, I have the Week, the Cost by Week, but I need a Formula for calculate the Cumulative Sum. On the Table EV_Management is where I charge the Cost by Activitie and…
- Rafael Sanchis
- Rafael_Sanchis
- updated 3 yrs ago
- 20replies
- 650
- 2
- Get help
- Answered
- Answered
Re: Group Sum Cost by Week
@Fred I close the DB and open it and work, sometimes things happend Yes Fred I have a Week field on the COST_W Table
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- Get help
- Reported - view
Re: Group Sum Cost by Week
let Wk := Week; concat((select COST_W)[Week = Wk]) My ID's in COST_W Begin on 9 and finish on 147 The Formula result Begin 101 and finish on 147 😯 I have 135 Registers
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- Get help
- Reported - view
Re: Group Sum Cost by Week
@Fred The Formulat give me Error: Field not Found Wk
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- Get help
- Reported - view
Group Sum Cost by Week

@Fred Need to sum cost for the group of week on the EV_Management table I try this formula but don't work let Wk := Week; sum((select EV_Management)[Week = Wk].…
- Rafael Sanchis
- Rafael_Sanchis
- updated 3 yrs ago
- 6replies
- 126
- Get help
- Answered
- Answered
Re: Concatanate - Two For loop -
let check := dialog(" ATENCION ", " ¿Confirma el SETUP de la tabla de AVANCES_PROYECTO ? ", ["Si", "No"]); if check = "Si" then for loop1 in select 'CUTOFF-DATES' do 'Date:' := loop1.…
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- Get help
- Reported - view
Re: Concatanate - Two For loop -
@Fred let check := dialog(" ATENCION ", " ¿Confirma el SETUP de la tabla de AVANCES_PROYECTO ? ", ["Si", "No"]); if check = "Si" then for loop1 in select 'CUTOFF-DATES' do 'Date:' := loop1.…
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- Get help
- Reported - view
Re: Concatanate - Two For loop -
@John Halls @Fred Hi again, The First Graph I generate with a loop is the Baseline Cost Curve (Alone), the second is the same generate with a one loop, I have 3 Curve the Baseline Cost Curve,…
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- Get help
- Reported - view
Re: SUM COST By CUTOFF_DATE
@Fred 😂 As easy as that, God I don't learn anything. Thanks Fred sorry agai
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- Get help
- Reported - view
Re: SUM COST By CUTOFF_DATE
@Fred I send you the DB take a look if you have time and excuse the abuse.🙁.
Attachment
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- Get help
- Reported - view
Re: SUM COST By CUTOFF_DATE
@Fred Not Fred sorry, Cost_V = Earned_V - Actual_Cost_Act and for now Actual_ Cost_Act is place manually. The Actual_ Cost_Act is need for Cost_V and CPI Formulas I try that first((select COSTO_W).…
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- Get help
- Reported - view
Re: SUM COST By CUTOFF_DATE
@Fred Hi Fred, there any Formula that can incluyde the Cost sum on the Field Actual_Cost_Act. (Now I place manually)
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- Get help
- Reported - view
Re: SUM COST By CUTOFF_DATE
@Fred Yes I want a weekly Breakdown of Cost. Now I place the cost in the EVM Table on the KPI' Activities Form in that form have the Field Actual_Cost here I charge the accumulated cost Week by Week,…
Attachment
- Rafael Sanchis
- Rafael_Sanchis
- 3 yrs ago
- Get help
- Reported - view

1 42 43 44 45 46 53

Welcome to the Ninox community

Rafael

Re: Suggestions from May 2022

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

How to Calculate Cumulative Sum

Re: Group Sum Cost by Week

Re: Group Sum Cost by Week

Re: Group Sum Cost by Week

Group Sum Cost by Week

Re: Concatanate - Two For loop -

Re: Concatanate - Two For loop -

Re: Concatanate - Two For loop -

Re: SUM COST By CUTOFF_DATE

Re: SUM COST By CUTOFF_DATE

Re: SUM COST By CUTOFF_DATE

Re: SUM COST By CUTOFF_DATE

Re: SUM COST By CUTOFF_DATE

Overview