Misbah 
-
Re: Level 2, Sprint 3- 3.3.6 Activity: Test the Shipping Cost Formulas
@ceeckman That's a great question. In-fact whenever I interview candidates this is one question that I keep on repeating. So here is the main difference between POST and OFFSET. When you want to…5 -
Re: Data type mismatch: format other than LIST or DATE being referenced as a relation
@Pilla What it means is that either your Role or Regions is not list formatted. One or both of them are being referenced as text. Can you please verify if both Region Line item and Roles Line item in…5 -
Re: Retrieving last non-zero value
@kenzael Unfortunately there is no LASTNONZERO function available, we will go for a workaround here. See if this helps Step 1: Create a line item call it Numerator. Write below formula in it IF '…5 -
Re: Convert Text date Range to period
@ShivankurSharma See if this helps.5 -
Re: Lead formula not allowed for formula summary
@Ana22 Easiest way and the simplest way is to break this into pieces. Don't Use LEAD function on the calculated Ratio instead use it on the inputs that you are using for calculating the Ratio. H…5
