Calculated dimension for money

[madhuqliklondon]

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. 

[Anonymous · Accepted solution]

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')

[sasiparupudi1]

if (TotalGBPExlVAT>=35 and TotalGBPExlVAT<=39.99, 'from 35.01 to 39,99','Over 40')

[Anonymous]

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

[madhuqliklondon]

Thank you all.