Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I am trying to write calculated expression , I have "if (TotalGBPExlVAT>=35, 'Over 35')" , what I am trying now is £35.01 to £39.99 and name as from 35.01 to 39,99. how do I write this.
Hi,
When I did something similar I used a nested if statement i.e.
if (TotalGBPExlVAT>=35, if (TotalGBPExlVAT<=39.99, 'from 35.01 to 39,99', 'Over 35')
Hi,
When I did something similar I used a nested if statement i.e.
if (TotalGBPExlVAT>=35, if (TotalGBPExlVAT<=39.99, 'from 35.01 to 39,99', 'Over 35')
if (TotalGBPExlVAT>=35 and TotalGBPExlVAT<=39.99, 'from 35.01 to 39,99','Over 40')
Hi
write the script for bucketing in back end to calculate Money dimension use that dimension in front end
=if (TotalGBPExlVAT>=35, 'Over 35',if(TotalGBPExlVAT>=35.01 and TotalGBPExlVAT<=39.99,'from 35.01 to 39,99')) as Money
Thank you all.