fbenoist68
/
mobileportal
1
0
Fork 0
Code Issues 739 Pull Requests Packages Projects Releases Wiki Activity

[FogBugz #730] Erreur sur le calcul des objectif #793

New Issue
Open
opened 2023-07-04 10:21:09 +02:00 by fbenoist68 · 3 comments
fbenoist68 commented 2023-07-04 10:21:09 +02:00
Owner

Assigned To: Frederik Benoist
Project: Mobile Portal
Area: Divers
Category: Bogue
Priority: A fixer impérativement

Assigned To: Frederik Benoist Project: Mobile Portal Area: Divers Category: Bogue Priority: A fixer impérativement
fbenoist68 commented 2023-07-04 10:21:10 +02:00
Poster
Owner

Event ID: 3811
Date: 2020-01-28T11:13:12Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Event ID: 3811 Date: 2020-01-28T11:13:12Z Person: Frederik Benoist Description: Modifié par Frederik Benoist
fbenoist68 commented 2023-07-04 10:21:12 +02:00
Poster
Owner

Event ID: 3810
Date: 2020-01-28T11:11:12Z
Person: Frederik Benoist
Description: Attribué à Frederik Benoist par Frederik Benoist

Event ID: 3810 Date: 2020-01-28T11:11:12Z Person: Frederik Benoist Description: Attribué à Frederik Benoist par Frederik Benoist
fbenoist68 commented 2023-07-04 10:21:15 +02:00
Poster
Owner

Event ID: 3809
Date: 2020-01-28T11:11:11Z
Person: Frederik Benoist
Description: Ouvert par Frederik Benoist

En effect les boutiques ayant fait 0 de C.A et donc avec un pourcentage de réalisation à 0 ne sont pas prises en compte



il faut mettre between 0 et pas 1



SUM (

          CASE

              WHEN    fid.obj_ca_net > 0

                    AND calc_pour (fid.n_ca_net, fid.obj_ca_net, -1) BETWEEN 0  <<<<<= ICI

                                                                        AND 49 -- a voir sinon < 0 ...

              THEN

                  1

              ELSE

                  0

          END)    AS btq_obj_natteint

Event ID: 3809 Date: 2020-01-28T11:11:11Z Person: Frederik Benoist Description: Ouvert par Frederik Benoist En effect les boutiques ayant fait 0 de C.A et donc avec un pourcentage de r&#233;alisation &#224; 0 ne sont pas prises en compte<br /> <br /> il faut mettre between 0 et pas 1<br /> <br /> SUM (<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CASE<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHEN&nbsp; &nbsp; fid.obj_ca_net &gt; 0<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AND calc_pour (fid.n_ca_net, fid.obj_ca_net, -1) BETWEEN 0&nbsp; &lt;&lt;&lt;&lt;&lt;= ICI<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AND 49 -- a voir sinon &lt; 0 ...<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; THEN<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ELSE<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; END)&nbsp; &nbsp; AS btq_obj_natteint
screenshot.png
33 KiB
screenshot.png
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
main
Labels
Clear labels
No items
No Label
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: fbenoist68/mobileportal#793
There is no content yet.
Delete Branch "%!s(<nil>)"

Deleting a branch is permanent. Although the deleted branch may exist for a short time before cleaning up, in most cases it CANNOT be undone. Continue?