topic Re: LM2 - Data Hub SYS13 - Formula Hint 2 in Academy & Training
https://community.anaplan.com/t5/Academy-Training/LM2-Data-Hub-SYS13-Formula-Hint-2/m-p/119009#M3363
<P>not enough <span class="lia-unicode-emoji" title=":disappointed_face:">ðŸ˜ž</span> if then else is missing for boolean format<BR />IF TIMESUM('DAT03 Historic Volumes'.Volumes) <> 0 THEN TRUE ELSE FALSE </P>Mon, 13 Sep 2021 10:07:02 GMTbenkoz752021-09-13T10:07:02ZLM2 - Data Hub SYS13 - Formula Hint 2
https://community.anaplan.com/t5/Academy-Training/LM2-Data-Hub-SYS13-Formula-Hint-2/m-p/69726#M1741
<P>Hi Team,</P><P> </P><P>In the Data Hub in module SYS13 Account SKU Filter you setup a Boolean line item to determine whether there is data in DAT03</P><P> </P><P>My formula to be used would of been: TIMESUM(DAT03) > 0 or TIMESUM(DAT03) <> 0</P><P> </P><P>The 2nd Anaplan formula hint is below:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Fornula Hint.PNG" style="width: 400px;"><img src="https://community.anaplan.com/t5/image/serverpage/image-id/33329iEA2CF0F0F64719EE/image-size/medium?v=v2&px=400" role="button" title="Fornula Hint.PNG" alt="Fornula Hint.PNG" /></span></P><P> </P><P>This is confusing as when/why would you use a Number (1/2) to determine the TRUE/FALSE nature rather than use the native Boolean logic of 0 & 1? </P><P> </P><P>Thanks</P><P> </P><P>Mark</P>Fri, 08 May 2020 19:36:17 GMThttps://community.anaplan.com/t5/Academy-Training/LM2-Data-Hub-SYS13-Formula-Hint-2/m-p/69726#M1741MarkTurkenburg2020-05-08T19:36:17ZRe: LM2 - Data Hub SYS13 - Formula Hint 2
https://community.anaplan.com/t5/Academy-Training/LM2-Data-Hub-SYS13-Formula-Hint-2/m-p/69749#M1746
<P>Hi <LI-USER uid="8288"></LI-USER> <BR /><BR />I feel there is a misunderstanding here. What are your concerns? I can see 3 concerns here: (correct me if I'm wrong)</P><P>1. There is a 1 / 2 in the THEN ELSE parts of the IF statement?</P><P>2. A TRUE FALSE should have been used instead</P><P>3. Native Boolean Logic of 0 &1 </P><P> </P><P>Let me start with the number 3. 0 and 1 and are not native Boolean logic. TRUE/FALSE are. </P><P>In the 3 parts of an IF THEN ELSE statement, the only part that should resolve to TRUE or FALSE is the part after the IF. However, the THEN and ELSE sections could resolve to ANYTHING -including Boolean. <BR /><BR />The Example provided literally translates to .... IF the condition of x not equal 1000 is met THEN resolve to or enter the value of 1, and if the condition is not met enter the value 2.<BR />an IF statement could be used in a line item of any format, in the example provided that format is NUMBER so whatever comes after the THEN and ELSE should resolve to NUMBER.<BR /> </P>Sat, 09 May 2020 12:38:07 GMThttps://community.anaplan.com/t5/Academy-Training/LM2-Data-Hub-SYS13-Formula-Hint-2/m-p/69749#M1746einas.ibrahim2020-05-09T12:38:07ZRe: LM2 - Data Hub SYS13 - Formula Hint 2
https://community.anaplan.com/t5/Academy-Training/LM2-Data-Hub-SYS13-Formula-Hint-2/m-p/69760#M1748
<P>Thanks <LI-USER uid="22938"></LI-USER> </P><P> </P><P>I think I wrote the post in haste as I was confused as to my formula was not approved as correct in the LM2 but then looking about at the 2nd post the example provided is not actually for the question & hence they were not using 1/2 as the answer</P><P> </P><P> </P>Sat, 09 May 2020 18:55:00 GMThttps://community.anaplan.com/t5/Academy-Training/LM2-Data-Hub-SYS13-Formula-Hint-2/m-p/69760#M1748MarkTurkenburg2020-05-09T18:55:00ZRe: LM2 - Data Hub SYS13 - Formula Hint 2
https://community.anaplan.com/t5/Academy-Training/LM2-Data-Hub-SYS13-Formula-Hint-2/m-p/73699#M1981
<P>Hi, and that formula to be used would be TIMESUM('DAT03 Historic Volumes'.Volumes) <> 0</P>Fri, 12 Jun 2020 16:47:09 GMThttps://community.anaplan.com/t5/Academy-Training/LM2-Data-Hub-SYS13-Formula-Hint-2/m-p/73699#M1981jmares2020-06-12T16:47:09ZRe: LM2 - Data Hub SYS13 - Formula Hint 2
https://community.anaplan.com/t5/Academy-Training/LM2-Data-Hub-SYS13-Formula-Hint-2/m-p/79777#M2215
<P>This is the formula I thought should work but when I try it I get an error saying "<SPAN>Invalid formula for 'SYS13 Account SKU Filter'.Has Data?: Automatic sum of 'DAT03 Historic Volumes'.Volumes over SKU Flat hierarchy is not possible as SKU Flat does not have a built-in top level" </SPAN></P><P>My DAT03 Historic Volumes module uses the SKU Flat list as instructed in the course. How can I solve this error?</P>Mon, 10 Aug 2020 10:32:53 GMThttps://community.anaplan.com/t5/Academy-Training/LM2-Data-Hub-SYS13-Formula-Hint-2/m-p/79777#M2215aaturnbu2020-08-10T10:32:53ZRe: LM2 - Data Hub SYS13 - Formula Hint 2
https://community.anaplan.com/t5/Academy-Training/LM2-Data-Hub-SYS13-Formula-Hint-2/m-p/79779#M2216
<P>Hello <LI-USER uid="35198"></LI-USER> <BR /><BR />Can you please share the instruction to use P3 SKU Flat in the historical volume module? I don't believe using the flat with this module is correct, and that's the reason for the error you are getting.</P>Mon, 10 Aug 2020 11:22:21 GMThttps://community.anaplan.com/t5/Academy-Training/LM2-Data-Hub-SYS13-Formula-Hint-2/m-p/79779#M2216einas.ibrahim2020-08-10T11:22:21ZRe: LM2 - Data Hub SYS13 - Formula Hint 2
https://community.anaplan.com/t5/Academy-Training/LM2-Data-Hub-SYS13-Formula-Hint-2/m-p/79863#M2219
<P>Here's the screenshot from the course:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="aaturnbu_0-1597100139694.png" style="width: 400px;"><img src="https://community.anaplan.com/t5/image/serverpage/image-id/37047i7C53B9E5F0459D9F/image-size/medium?v=v2&px=400" role="button" title="aaturnbu_0-1597100139694.png" alt="aaturnbu_0-1597100139694.png" /></span></P><P>It clearly says to use the flat list.</P><P> </P><P>I found the problem though, I was not using the flat list in SYS13, I had selected the P3 SKU hierarchical list by mistake. It works now that both modules are using the flat list.</P>Mon, 10 Aug 2020 23:25:25 GMThttps://community.anaplan.com/t5/Academy-Training/LM2-Data-Hub-SYS13-Formula-Hint-2/m-p/79863#M2219aaturnbu2020-08-10T23:25:25ZRe: LM2 - Data Hub SYS13 - Formula Hint 2
https://community.anaplan.com/t5/Academy-Training/LM2-Data-Hub-SYS13-Formula-Hint-2/m-p/119009#M3363
<P>not enough <span class="lia-unicode-emoji" title=":disappointed_face:">ðŸ˜ž</span> if then else is missing for boolean format<BR />IF TIMESUM('DAT03 Historic Volumes'.Volumes) <> 0 THEN TRUE ELSE FALSE </P>Mon, 13 Sep 2021 10:07:02 GMThttps://community.anaplan.com/t5/Academy-Training/LM2-Data-Hub-SYS13-Formula-Hint-2/m-p/119009#M3363benkoz752021-09-13T10:07:02Z