Msgbox

[#1]

Hi ,

Is it possible to use the Msgbox function in the expression in Straight or Piviot table.

for ex:

=if(a< b, sum(CID),Msgbox("A should be less than b"))

Regards,XXX

[#2 · Accepted solution]

Instead of using a message box, you can use the calculation condition to highlight the required text when the calculation condition is not satisfied. Use the below expression in the 'Calculation Condition' property under the 'General' tab

=if(a< b, true(),false())

The required error message can be entered by using the 'Error Messages' button in the 'General' tab.