I need to do 2 calculations (Substract and Division) on 2 fields (This Year and Last Year)
after the first transformation, I put Alias = ‘front’
and hoping I could see ‘front’ on the second transformation
why I couldnt see ‘front’ from the dropdown?
it does appear if I put the 2 queries into 1 query
why doesnt it appear for 2 queries…?