03-28-2017 03:10 PM - edited 03-28-2017 03:11 PM
I m trying to create a calculated fieldfor a report. I have to create an item with a range and I using If else boolean for this. Here, i have to get the output as numeric with combination of date and numeric. i m not able to create an item with date and range between numeric where as the ouput should be a nuemeric. Please suggest..
03-28-2017 03:31 PM
Can you provide some more information about the calculated expression that you want to create?
Do you need to compare numerics and dates?
It wouldn't be as simple as something like this would it?
IF ( 'Date'n BetweenInclusive('7MAR2017'd, '28MAR2017'd) ) RETURN 'Profit'n ELSE .
03-29-2017 09:02 AM