on ‎2017 May 23 3:31 PM
Hi Bpc Friends
I have a script with the following conditional logic but I don't understand the code
[ENTITY].[DEFAULT],[PRODUCTGRP].[NO_PRODGRP])>0
*WHEN COSTCENTRE
*IS *
*REC(FACTOR=(([ENTITY].[DEFAULT],[PRODUCTGRP].[NO_PRODGRP])>0),COSTCENTRE=GSSALLOC_REV)
*ENDWHEN
Help others by sharing your knowledge.
AnswerRequest clarification before answering.
Ternary syntax will be:
([ENTITY].[DEFAULT],[PRODUCTGRP].[NO_PRODGRP])>0 ? 1 : 0
Condition ? ValueIfTrue : ValueIfFalse
Factor will be equal to 1 if true and 0 if false
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
old syntax! Rewrite using ternary operator.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 30 | |
| 6 | |
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.