You Can first Convert String To Date To get CORRECT Results. Pl Post Some Data if you need help in conversion.
Both data look like this:
I can use QE Date as a Date field. But I should not convert Parameter 2 to date as it is used in other places. So, only way is to convert to date in a calculated field. How do you convert string to date like the above format.
Basically, user will choose one date from the parameter, and the report should only show data for the last five quarters.
1 of 1 people found this helpful
I Think You can Follow this. It was Similar to Yours.
Just Split Your Column into Year and Quarter Using Custom Split in Data view or
SPLIT(Your String Date," ")
and Then Follow this;
1. Quarter = SPLIT([Quarter End]," ",2)
2. Year = LEFT([Quarter End],4)
3. Quarter Number =
(IF INT(RIGHT([1. Quarter]),1)=1 Then 1
ELSEIF INT(RIGHT([1. Quarter]),1)=2 Then 4
ELSEIF INT(RIGHT([1. Quarter]),1)=3 Then 7
3rd formula is giving error : RIGHT is being called with (string), did you mean (string, float) ?
This one works for step 3:
IF INT(RIGHT([1. Quarter],1))=1 Then 1
INT(RIGHT([1. Quarter],1))=2 THEN 4
INT(RIGHT([1. Quarter],1))=3 THEN 7
Then You may Please Close Thread by Marking The Reply CORRECT.