Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
May i know how to sum up the below script ?
if(right(@162:174T,1)='-', '-' & left(@162:174T, len(@162:174T)-1),@162:174T) as ab18, |
if(right(@179:191T,1)='-', '-' & left(@179:191T, len(@179:191T)-1),@179:191T) as ab21, |
I try below , it does not work :-
sum( | |
if(right(@162:174T,1)='-', '-' & left(@162:174T, len(@162:174T)-1),@162:174T)) | |
+ | |
sum( | |
if(right(@179:191T,1)='-', '-' & left(@179:191T, len(@179:191T)-1),@179:191T)) | |
as ab1821, |
How about this:
RangeSum(
If(Right(@162:174T,1)='-', '-' & Left(@162:174T, Len(@162:174T)-1),@162:174T),
If(Right(@179:191T,1)='-', '-' & Left(@179:191T, Len(@179:191T)-1),@179:191T)) as ab1821
How about this:
RangeSum(
If(Right(@162:174T,1)='-', '-' & Left(@162:174T, Len(@162:174T)-1),@162:174T),
If(Right(@179:191T,1)='-', '-' & Left(@179:191T, Len(@179:191T)-1),@179:191T)) as ab1821
THank you sunny , it work
Awesome, I am glad it did