We have a seasonal service product that runs over the course of eight weeks in summer. There's a minimum of two weeks use. You have to start on Monday and finish on a Friday. With that in mind, I created a drop-down menu to choose a start date. Then one of seven drop-downs appears with finish date options. IF logic used to display each one.
At the end of that, I wanted a calculation to pick out the Amount for each no matter which start/end date there was. So another IF statement:
=(if StartDate = "27 June 2016" THEN EndDate0_Amount ELSE "")+ (if StartDate = "4 July 2016" THEN EndDate1_Amount ELSE "")+ (if StartDate = "11 July 2016" THEN EndDate2_Amount ELSE "")
Field name: Costpreconv
This gives the correct amount as in Text format (amount dictated as numerical/currency amount using Cognito functionality).
However, whenever I try to parse that to a decimal or currency it's not working.
Returns nothing at all
And if I don't use Decimal.Parse, it says
'The expected type of this field is 'Decimal' at character 0'